Moving a WordPress site from one server to another has always been a bit of a pain. You need to deal with all the website files, the plugins, images, and of course the database. Throw in a domain name change and the whole process gets downright frightening – however using the fantastic All-in-One WP Migration Plugin by ServMask, migrating a website has never been easier!
There’s only one issue that I’ve run into but I’ve FINALLY found a solution. Occasionally All-in-One WP Migration will move all the files, install all the plugins but when you get to the Restoring Database stage, everything just freezes. You can wait for hours but nothing will change.
Seriously, search for All-in-One WP Migration Stuck Restoring Database on Google and you will be inundated with help forums and web pages offering solutions.
I’ve searched for a solution countless times but the posted answer is ALWAYS the same. And it has NEVER worked. I would still recommend trying the 3 step plan that involves waiting 15 minutes, opening a new tab, logging into the new website and saving the Permalinks settings. It’s great in theory (and it must work for some people) but it has NEVER worked for me.
Finally I found a solution buried deep within the comments on a random help forum and they have worked every time I’ve had this issue.
Using Plesk, select PHP Settings for the domain you’re having trouble with and increase the max_execution_time and max_input_time to their maximum settings. Most servers default to 30 and 60 seconds respectively – when I increased both settings to 120 seconds the migration worked flawlessly. If you still have issues you should try increasing the memory available to PHP in your WP-Config file as well.
If you’re not using Plesk there are lots of other ways to increase the max_execution_time setting, just ask your web host to help you out – any reputable host should be able to assist you.
Seriously, your restoring database issues with All-in-One WP Migration are over. Just tweak your PHP settings before migrating your next website and it should work every single time. I can’t say enough how much I love All-in-One WP Migration, and this trick eliminates my only issue with the plugin!
The free version of All-in-One WP Migration, available on the WordPress Plugin Depository, allows migrations of website up to 512 MB in size. ServMask also offers a paid version of the plugin, All in One WP Migration Unlimited Extension that is $45 and has no size limitations.