Title: Severe database error when restoring Last modified: April 7, 2021 --- # Severe database error when restoring * Resolved [bestofbonus](https://wordpress.org/support/users/bestofbonus/) * (@bestofbonus) * [5 years, 2 months ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/) * Hi, * Lately all of my restores fail in a way that they start and then abort with this message when I click “Return to Updraft configuration”: [http://prntscr.com/116m26t](http://prntscr.com/116m26t) * The database repair doesn’t help anything. After that I can’t enter my site anymore because a connection to the database can’t be established. * The only reason I got my site back running was because of a backup through my host. * I cannot tell what is wrong. The backups finish without error messages and my database looks quite normal as it always did. * Here’s the log from a failed restore: [https://pastebin.com/GE6CKc8E](https://pastebin.com/GE6CKc8E) * I hope someone has an idea. * Thanks and Cheers, Stan Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/topic/severe-database-error-when-restoring/page/2/?output_format=md) [→](https://wordpress.org/support/topic/severe-database-error-when-restoring/page/2/?output_format=md) * Plugin Contributor [bcrodua](https://wordpress.org/support/users/bcrodua/) * (@bcrodua) * [5 years, 2 months ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14290031) * 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 * Thread Starter [bestofbonus](https://wordpress.org/support/users/bestofbonus/) * (@bestofbonus) * [5 years, 2 months ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14290797) * Hi Bryle, * Yes, I have the newest version installed. Error comes when restoring backups from the current as well as previous versions. * Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/) * (@davidanderson) * [5 years, 1 month ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14382037) * 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 * Thread Starter [bestofbonus](https://wordpress.org/support/users/bestofbonus/) * (@bestofbonus) * [5 years, 1 month ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14386195) * Hi David, * I now made another backup without issues and the restore failed as previously: [https://pastebin.com/DXvEFUr0](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 * Plugin Contributor [bcrodua](https://wordpress.org/support/users/bcrodua/) * (@bcrodua) * [5 years, 1 month ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14408352) * 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 * Thread Starter [bestofbonus](https://wordpress.org/support/users/bestofbonus/) * (@bestofbonus) * [5 years, 1 month ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14417981) * Hello, * You mean I should go to phpMyAdmin and import the database file that Updraft created in the backup? * As described here: [http://prntscr.com/12qjary](http://prntscr.com/12qjary) * Cheers, Stan * Plugin Contributor [bcrodua](https://wordpress.org/support/users/bcrodua/) * (@bcrodua) * [5 years, 1 month ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14430995) * Hi Stan, * Yes, that is right. * Regards, Bryle * Thread Starter [bestofbonus](https://wordpress.org/support/users/bestofbonus/) * (@bestofbonus) * [5 years ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14442373) * 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](https://drive.google.com/file/d/1319K4R1bruqgbgULFn54yaWVKG-74F3f/view) * Thank you and best regards, Stan * Plugin Contributor [bcrodua](https://wordpress.org/support/users/bcrodua/) * (@bcrodua) * [5 years ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14459413) * 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 [http://pastebin.com/](http://pastebin.com/)). * I will ask my colleague to check and see if there is anything that we can improve from our end. * Thanks, Bryle * Thread Starter [bestofbonus](https://wordpress.org/support/users/bestofbonus/) * (@bestofbonus) * [5 years ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14472433) * 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=](https://zerobin.net/?3b4dcf7c2ec04a4a#LDFFdG/u7EsxXHZFODSK19KGg2YxZV2bt8Fc2IdipG0=) * It’s from the last failed restore I tried. * Thank you and best regards, Andy * Plugin Support [vupdraft](https://wordpress.org/support/users/vupdraft/) * (@vupdraft) * [5 years ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14479804) * [@bestofbonus](https://wordpress.org/support/users/bestofbonus/) -What DB prefix are you using? * Thread Starter [bestofbonus](https://wordpress.org/support/users/bestofbonus/) * (@bestofbonus) * [5 years ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14479990) * 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 * Plugin Contributor [aporter](https://wordpress.org/support/users/aporter/) * (@aporter) * [5 years ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14480034) * 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 * Thread Starter [bestofbonus](https://wordpress.org/support/users/bestofbonus/) * (@bestofbonus) * [5 years ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14530165) * 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: [http://prntscr.com/14kwf93](http://prntscr.com/14kwf93) * Goes back to normal when I delete this line. * Best regards, Stan * Thread Starter [bestofbonus](https://wordpress.org/support/users/bestofbonus/) * (@bestofbonus) * [4 years, 11 months ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/#post-14578532) * 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 Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/topic/severe-database-error-when-restoring/page/2/?output_format=md) [→](https://wordpress.org/support/topic/severe-database-error-when-restoring/page/2/?output_format=md) The topic ‘Severe database error when restoring’ is closed to new replies. * ![](https://ps.w.org/updraftplus/assets/icon-256x256.jpg?rev=1686200) * [UpdraftPlus: WP Backup & Migration Plugin](https://wordpress.org/plugins/updraftplus/) * [Frequently Asked Questions](https://wordpress.org/plugins/updraftplus/#faq) * [Support Threads](https://wordpress.org/support/plugin/updraftplus/) * [Active Topics](https://wordpress.org/support/plugin/updraftplus/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/updraftplus/unresolved/) * [Reviews](https://wordpress.org/support/plugin/updraftplus/reviews/) ## Tags * [Database Error](https://wordpress.org/support/topic-tag/database-error/) * [restore](https://wordpress.org/support/topic-tag/restore/) * 17 replies * 5 participants * Last reply from: [bestofbonus](https://wordpress.org/support/users/bestofbonus/) * Last activity: [4 years, 11 months ago](https://wordpress.org/support/topic/severe-database-error-when-restoring/page/2/#post-14613258) * Status: resolved