This tutorial shows how to migrate a WordPress with without installing any unnecessary plugins.
1) Backup/Export existing MySQL database.
2) At the new hosting site; create a new database and import the data exported in step-1.
3) In case old and new site URLs are exactly the same; no change is needed in the database.
Else, in table “wp_options” change the “option_value” of first two records – “siteurl” and “home” as per the new site.
NOTE: The URL should end with a front slash “/”.
4) Export your entire site code using a cpanel or any file transfer client like Filezilla; and import or dump at your new site.
5) Change the following database configurations in your “wp-config.php” file. ‘DB_NAME’, ‘DB_USER’, ‘DB_PASSWORD’, ‘DB_HOST’; and save.
NOTE: ‘DB_HOST’ is ‘localhost’ in most cases; but not always (as in case of AWS).
6) In case, links are not working for your internal pages (Optional).
login to WP-admin -> setting -> paralinks -> add “/index.php” in front of custom structure and save changes.
Example – “https://01wise.com/index.php/%postname%/“
You are all done.
Please let me know in case this is not working in your situation.