Fail to Connect to Account

[gerrardpierceUser]

This is where it fails…

Restoring table (MyISAM): wp_myarcadegames
Database lines processed: 750 in 55.72 seconds
Search and replacing table: wp_myarcadegames: rows: 38963

So another big table. A copy of the DB is on it’s way.

Many thanks for your continued assistance! :D

[gerrardpierceUser]

BTW, if I deactivate a plugin, does that prevent it’s table from being backup up/migrated?

[udadminKeymaster]

Hi Gerrard,

I’ll take a look at this and see if the new code we’ve done makes a difference (to the out-of-memory) – I’ll get back to you this evening, all being well.

The timeout may be more challenging, though – if you’ve got such an enormous database and plan to import/export it through a web browser then really you need to buy (or configure, if it’s a dedicated server) web hosting where they have generous timeouts…

David

[udadminKeymaster]

Hi Gerrard,

I was able to migrate using that database without problems; no SQL statement was longer than 0.5Mb, and maximum memory usage was 95Mb. So there must be something in the environment of the site you’re migrating into that is causing the problem and using up the 256Mb – are there other plugins already active that you could disable? Or a non-default theme?

David

[gerrardpierceUser]

Hmmm. Host timeout is 10 minutes so that shouldn’t be a problem. The only other plugin activated was Akismet and even after it is disabled, I get exactly the same result in exactly the same place. And the theme is default. It is a clean install.

[udadminKeymaster]

Hi Gerrard,

Are you migrating other components as well as the database? If so, then can you share those with me too, so that I can test them?

It may be that your PHP install is dodgy and has bugs that cause the leaking of memory. If I can successfully migrate your site without using much memory, then I’ll send you a new version that will print on the screen the memory usage for you so that we can test that hypothesis.

David

[gerrardpierceUser]

Yes, but I have also tried it with just the database with the same result. And when I did try the full import/migrate, the process never got to the stage of importing other components or files so the site is still clean.

[udadminKeymaster]

Hi,

As you have no other plugins installed, and as it does the database first, it sounds like your web hosting company has a dodgy PHP install that leaks memory. What version is it, BTW?

I’m emailing you a new version of migrator that will print out the memory usage after every SQL command, so that we can see at what point it’s growing.

David

[gerrardpierceUser]

Thank you for sending the new version. Unfortunately, after deleting the installed version and installing the new one, the restore failed with the following message…

Code:

Backup of: https://www.gamerdads.co.uk
Old table prefix: wp_
Site information: multisite = 0
Memory usage (Mb): 28.7 : 30.8
Memory usage (Mb): 28.7 : 30.8
Memory usage (Mb): 28.7 : 30.8
Memory usage (Mb): 28.7 : 30.8
Memory usage (Mb): 28.7 : 30.8
New table prefix: wp_
Memory usage (Mb): 28.7 : 30.8
Restoring table (InnoDB): wp_options
Memory usage (Mb): 28.7 : 30.8
Memory usage (Mb): 29 : 32
Memory usage (Mb): 28.8 : 32
Memory usage (Mb): 28.8 : 32
Memory usage (Mb): 28.9 : 32
Memory usage (Mb): 28.8 : 32
Memory usage (Mb): 28.9 : 32
Memory usage (Mb): 28.8 : 32
Memory usage (Mb): 28.8 : 32
Memory usage (Mb): 28.8 : 32
Memory usage (Mb): 29.3 : 33.3
Memory usage (Mb): 28.7 : 33.3
Memory usage (Mb): 28.7 : 33.3
Search and replacing table: wp_options
Fatal error: Call to undefined method UpdraftPlus::backquote() in /var/sites/t/test.gamerdads.co.uk/public_html/wp-content/plugins/updraftplus/addons/migrator.php on line 456

[udadminKeymaster]

Hi,

Sorry – I’ve sent another. (I sent you our development branch, which hasn’t yet gone through the usual pre-release testing… you found an error!).

David

[gerrardpierceUser]

Not a problem. I’m happy to help!!

[gerrardpierceUser]

The latest update certainly got us past the memory issue and it carried on for much longer, but then seemed to timeout again, and the site becomes inaccessible (both front end and wp-admin). So thank you for resolving the memory issue but it seems that the host’s claim of a 10 minute timeout might be inaccurate?

I am attempting to set up a hyper-v hosted/centos linux hosted wp installation on our rented server which will give us full control over the backend. So unless you have any more suggestions on the timeout issue, I will wait to try again until I can get our own server up and running?

[udadminKeymaster]

Hi Gerrard,

In a future version, which you’ll get via an update, we plan to restore non-core tables over AJAX in order to work around potential time-outs… but that’ll not arrive for a while yet. So in the meantime, yes, you’ll need to find a way to get more generous timeouts. On my cheap Pentium laptop, I didn’t time the restoration, but I’d say it was something like 4 minutes.

David

[gerrardpierceUser]

I just wanted to let you know that after setting up my own dedicated WordPress server using a TurnkeyLinux vmware appliance on a new ESXi server, I ran the migration routine and it worked beautifully!

However, for a while the site was blank, nothing appeared at all, so I restarted the server and once again, nothing but after a few minutes, it appeared and was a perfect replica. The next issue was that wp-admin gave a 500 error, but that turned out to be an issue with memory limit in settings (https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-internal-server-error-in-wordpress/).

Then it was perfect!

[udadminKeymaster]

Hi Gerrard,

Great, glad you got it fixed. Out of interest, what was your memory limit before and after changing the value?

David

[Author]

Posts