New answers tagged migration
I highly recommend updating all of your URLS. This can be done either with a word press plugin such as Velet Blues Update URLS Or via your SQL database: UPDATE wp_posts set post_content=REPLACE(post_content, 'www.live.com/', 'www.test.com/'); note* images are uploadeded as posts in your database.* ( wp_posts table with a post_type of "attachment". )
You can simply copy the password from wp-config.php to reset the password of the user. Then, if you have phpMyAdmin, check that you can login with the user and the password. If you can't log in phpMyAdmin, check that the user has access to the database. If nothing work, there's probably something wrong with the server.
Make sure the new server host is the same as the old one ... some hosting services require you to put for example : vps.myhost.x1.com .... instead of localhost ... Edit : To be sure there's something wrong around your database! whether it is the IP, the host the mysql user/password ... double checkout from your wp-config.php and make sure you database has ...
The database prefix is probably different on the new server. Make sure they match or you can change the prefix accordingly in your wp-config file. The prefix line in your wp-config file looks something like this: $table_prefix = 'wp_';
Try using the 10up/MU-Migration command: https://github.com/10up/MU-Migration
If your multi-site install only has a small number of subsites, you might find it easier to just use the export and import tools from the administration area. For each site in the multi site install, you can download an export file that contains blog posts, pages, users, comments etc. Then you can import all these into the same single site. Might be easier ...
Top 50 recent answers are included