COAP:COAP-3110/week6: Difference between revisions

The educational technology and digital learning wiki
Jump to navigation Jump to search
mNo edit summary
Line 32: Line 32:
define('DB_HOST', 'mysql5.000webhost.com');
define('DB_HOST', 'mysql5.000webhost.com');
</source>
</source>
'''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 <code>utf8mb4</code> by <code>utf8</code>

Revision as of 17:57, 13 September 2016

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