COAP:COAP-3110/week6

Week 6 learning goals

• Migrating from a development server to a hosting company
• The REST protocol

Monday

In order to migrate you will have to:

• copy all the WordPress files using an FTP or SFTP client or a WebClient (depending on the hosting company)
• dump the whole database to a *.zip file
• Create a copy of the wp-config.php file and edit some settings

On the new host

• Create a new database
• Write down its full name, database user name, database user password, machine name
• Edit config.php, the replace your original wp-config.php file by this new version

Example taken from 000webhost.com:

as you can see the hosting organization may force you to adopt some prefix, i.e. the a3966289 would represent your user id.

define('DB_NAME', 'a3966289_w');

/** MySQL database username */
define('DB_USER', 'a3966289_user');

/** MySQL database password */
define('DB_PASSWORD', 'XXXXXXXX');

/** MySQL hostname */
define('DB_HOST', 'mysql5.000webhost.com');

Trouble

• You provide may use an old mysql version that does not support the extend utf8mb4 caracter set. Open the *.sql file in a text editor and replace utf8mb4 by utf8