Have you noticed, there is all kinds of advise on the internet about the best way to move WordPress websites? There is literally a myriad of ways to achieve this. One of the methods I read on
wp.com was:
Changing Your Domain Name and URLs
Moving a website and changing your domain name or URLs (i.e. from http://example.com/site to http://example.com, or http://example.com to http://example.net) requires the following steps - in sequence.
Download your existing site files.
Export your database - go in to MySQL and export the database.
Move the backed up files and database into a new folder - somewhere safe - this is your site backup.
Log in to the site you want to move and go to Settings > General, then change the URLs. (ie from http://example.com/ to http://example.net ) - save the settings and expect to see a 404 page.
Download your site files again.
Export the database again.
Edit wp-config.php with the new server's MySQL database name, user and password.
Upload the files.
Import the database on the new server.
I mean this is truly horrifying steps to take, and I don’t see the point at all. This is how I achieved it for one my customers.
1. Take customer Database Dump
2. Edit the database searching for 'siteurl' with vi
vi mysqldump.sql
:?siteurl
And just swap out the values, confirming after editing the file;
[root@box]# cat somemysqldump.sql | grep siteurl -A 2
(1, 'siteurl', 'https://www.newsiteurl.com', 'yes'),
(2, 'home', 'https://www.newsiteurl.com', 'yes'),
(3, 'blogname', 'My website name', 'yes'),
Job done, no stress https://codex.wordpress.org/Moving_WordPress.
There might be additional bits but this is certainly enough for them to access the wp-admin panel. If you have problems add this line to the wp-config.php file;
define('RELOCATE',true);
Just before the line which says
/* That’s all, stop editing! Happy blogging. */
And then just do the import/restore as normal;
mysql -u newmysqluser -p newdatabase_to_import_to < old_database.sql
Simples! I really have no idea why it is made to be so complicated on other hosting sites or platforms.