Severe database error when restoring

Hi Stan,

Can you confirm that you are using the latest version of our plugin 1.16.53? If not, please update and test the restoration process.

Thanks,
Bryle

Hi Bryle,

Yes, I have the newest version installed.
Error comes when restoring backups from the current as well as previous versions.

Hi,

Apologies for the delay; we have had staff away due to health reasons. Unfortunately the pastebin link has expired – are you able to post another?

David

Hi David,

I now made another backup without issues and the restore failed as previously:
https://pastebin.com/DXvEFUr0

I enabled the WP Cron Job but that wasn’t the issue.
I also need to mention that my database doesn’t have the “wp_” prefix and I get this warning before a restore but for months that never created any problems and Updraft worked great.

Cheers,
Andy

Hi Andy,

Please can you drop the current database and manually restore the database via phpMyAdmin. Does that fix the database restoration issue?

Regards,
Bryle

Hello,

You mean I should go to phpMyAdmin and import the database file that Updraft created in the backup?

As described here: https://prntscr.com/12qjary

Cheers,
Stan

Hi Stan,

Yes, that is right.

Regards,
Bryle

Hello Bryle,

Yes, I can fix the database like this and log in again. It also looks like before the crash. That means the database file itself doesn’t seem to be corrupted. There’s something Updraft can’t seem to process.

I made a quick screencast to visualize what happens every time: https://drive.google.com/file/d/1319K4R1bruqgbgULFn54yaWVKG-74F3f/view

Thank you and best regards,
Stan

Hi,

Apologies for the delay.

Can you send us a copy of the database restoration log? You can find this log in the ‘wp-content/updraft’ directory of your site via FTP.
You can send the log file and copy the contents into an online tool (such as https://pastebin.com/ ).

I will ask my colleague to check and see if there is anything that we can improve from our end.

Thanks,
Bryle

Hello Bryle,

It’s a very large txt file. Pastebin wouldn’t allow me to post it but I found an alternative:

https://zerobin.net/?3b4dcf7c2ec04a4a#LDFFdG/u7EsxXHZFODSK19KGg2YxZV2bt8Fc2IdipG0=

It’s from the last failed restore I tried.

Thank you and best regards,
Andy

@bestofbonus -What DB prefix are you using?

My database has no prefix. It was set up like this in the beginning.
I always see the warning before restoring but I still did it successfully many times with this database.

Cheers,
Stan

Hi Stan,

Could you add this to your wp-config.php and try the restore again

define(‘UPDRAFTPLUS_ATOMIC_RESTORE_DISABLED’, true);

Best Wishes,

Ashley

Hello Ashley,

I did that. I can’t test anything because I can’t enter my page anymore, front or backend. This is the error message I see: https://prntscr.com/14kwf93

Goes back to normal when I delete this line.

Best regards,
Stan

Hello,

I wanted to ask again if this is a known issue and if there’s any explanation for this behavior?

Would getting the premium version maybe change something about this?

Cheers,
Stan