I just made a Wordpress website on a local server (easyPHP) and it works great. Now it is time to move it to my host server, but I am facing a problem. After migrating the website, I noted that all special characters are replaced by a "?". And in the admin dashboard, when I check my pages, all pages title that are supposed to contain special characters are empty (Only the title) and some of their custom fields does not exist anymore. One more thing, I use the "Custom Post Type UI" plugin, and all posts created with it are not displayed. Now, for the steps I made to migrate are : Export local database from phpmyadmin, in UTF-8 format (I let all the default settings). Upload my local website files to the server (the wordpress folder itself). Import my local database to the server by phpmyadmin Change the "option_value" field from "siteurl" and "home" rows from the "wp_options" table to my server url. Changed the database access from the "wp-config.php" file Gone to the wp-admin panel in general tab and clicked "save", same thing for permalink tab. After that, I exported my new database to check if it contained any instance of my local URL and it did not. I have now no idea why I get this problem. I think this is an encoding problem but don't know nothing more. Any one could help me? For information, there are my local and host setup : Local Wordpress 4.2.4 PHP 5.5.8 MYSQL 5.6.15 Database collation : utf8mb4_unicode_ci Table storage engine : MyISAM Table collation : utf8mb4_unicode_ci Row collation : utf8mb4_unicode_ci Host server PHP 5.4.24 MYSQL 5.5.42-37.1-log Database collation : utf8mb4_unicode_ci

Reputation: 310

Migrating wordpress from local server to host

I just made a Wordpress website on a local server (easyPHP) and it works great. Now it is time to move it to my host server, but I am facing a problem. After migrating the website, I noted that all special characters are replaced by a "?". And in the admin dashboard, when I check my pages, all pages title that are supposed to contain special characters are empty (Only the title) and some of their custom fields does not exist anymore. One more thing, I use the "Custom Post Type UI" plugin, and all posts created with it are not displayed.

Now, for the steps I made to migrate are :

Export local database from phpmyadmin, in UTF-8 format (I let all the default settings).
Upload my local website files to the server (the wordpress folder itself).
Import my local database to the server by phpmyadmin
Change the "option_value" field from "siteurl" and "home" rows from the "wp_options" table to my server url.
Changed the database access from the "wp-config.php" file
Gone to the wp-admin panel in general tab and clicked "save", same thing for permalink tab.

After that, I exported my new database to check if it contained any instance of my local URL and it did not.

I have now no idea why I get this problem. I think this is an encoding problem but don't know nothing more. Any one could help me?

For information, there are my local and host setup :

Local