I'm currently migrating between VPS hosts for my Wordpress sites. I have a number of sites that I've transferred with Snapshot Pro flawlessly, but my largest website is giving me a major headache.
Exporting the database via Snapshot Pro works just fine - importing/restoring however, not so much. The process always remains stuck at the "postmeta" entry. I have a large number of tables here (300360), and it always gets stuck at 100% and 300000 tables. The 600 other tables are forgotten. Snapshot then freezes and is unable to migrate the website.
I've tried reducing the number of tables to below 300000 by removing a few posts, but that didn't help either. The restore function only goes up to a certain point (such as 299000 when I had 299447 tables) and fails to restore the rest of the tables which results in total failure. I get a standard error message a couple of minutes after.
If I exclude the post metadata, the transfer works fine. But, it's really necessary to transfer the post metadata as well.