Restoring Uploads directory Issue

[DianaParticipant]

I have my backups on S3 and when I do a restore (whilst migrating a site) everything goes fine until the process tries to restore the uploads backup. Then I get this…

0004.451 () Unpacking backup… (backup_2018-07-23-1359_some_company_Ltd_d6fdc49d885d-uploads.zip, 307.7 Mb)

And that’s it. After that nothing happens.

I have increased a few settings in the php.ini file.

max_execution_time 120 120
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time 60 60
max_input_vars 1000 1000
memory_limit 256M 256M

Any ideas? Client becoming impatient.

TIA

Alex

[Bryle CroduaModerator]

Hi Alex,

It appears migration process has been timed our or being killed off while extracting the uploads.zip.

Please could you ask your hosts/server admin and have them check the PHP error logs. These logs should contain a record of the exact information as to why the process could not complete.

Regards,
Bryle

[DianaParticipant]

Hi Bryle

I got the error log from /var/log/httpd/error_log and it says:

[Tue Jul 24 08:12:06.477035 2018] [:error] [pid 24608] [client 12.34.56.78:11111] WordPress database error Access denied; you need (at least one of) the SUPER privilege(s) for this operat$
[Tue Jul 24 08:12:55.315114 2018] [:error] [pid 24608] [client 12.34.56.78:2222] WordPress database error Access denied; you need (at least one of) the SUPER privilege(s) for this operat$
[Tue Jul 24 08:12:58.266971 2018] [:error] [pid 24608] [client 12.34.56.78:33333] WordPress database error Access denied; you need (at least one of) the SUPER privilege(s) for this operat$

And yet the site can be accessed through a web browser so it is apparently connected to the database.

Any ideas would help.

[Dee NutbourneModerator]

Hi,

The errors in the site error log are from UpdraftPlus testing if it has certain permissions for the database.

To finish the restoration, I would recommend restoring the Uploads backup manually for now.
To do so, download the Uploads section of the backup, unzip the file(s), and upload the contents to the ‘wp-content/uploads’ directory of the site via FTP.
Then, restore the other sections of the backup via UpdraftPlus.

Could you then send us a copy of the latest few restoration logs? We can then attempt to determine what the cause of the issue was.
These can be found in the ‘wp-content/updraft’ directory of the site.
The contents will be too long to post here directly, but you can use an online service such as Dropbox or Pastebin, and post the links here.

Best Wishes,
David N

[Author]

Posts