Share this page : facebooktwitterlinkedinmailfacebooktwitterlinkedinmail

Yesterday I could not stand the old server’s turtle speed and decide to migrate my WordPress to a new host. My scenario is keeping the Domain name, just change the hosting provider. After I tried the method from website like this one, the pages work fine, but when I tried to access the dashboard, I continuously experienced the error 404. Then I tried another way and it works.

Step1, remove some plugins that contains redirection function, this may cause error 404 after the migration. Such as Cache plugins, Theme my login, register related plugins etc. Because these plugins may change the setting in .Htaccess file, therefore cause the error.

Step2, follow the instruction in the link which including backup database, backup site files, restore database, restore files, use Search Replace DB to edit database. The last step is  crucial, In order for images and posts linking to other parts of your site to work, you’ll need to update your domain name in your database.

if you have trouble with import database from phpMyAdmin, then think about ftp the database file to the server, import from mysql command:

mysql -u username -p database_name < file.sql

Issue:

#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

solution:

  1. Open database file with text editor, replace utf8mb4_unicode_520_ci with utf8_unicode_ci for collation.

2. remove previous Database, create an empty database with utf8_unicode_ci, then try to import the database file.

Step3, test the page, wp-admin, plugins, media. If any plugin encounters error, better to remove it and reinstall, because the database and plugin may not coordinate with each other after the migration.