UpdraftPlus Home › Forums › Paid support forum – UpdraftPlus backup plugin › Cannot restore database from backup
- This topic has 4 replies, 2 voices, and was last updated 6 years, 2 months ago by Dee Nutbourne.
-
AuthorPosts
-
January 12, 2018 at 1:30 pm #254552a.weimannParticipant
Since yesterday, when I restore the database with updraft plus, I get an error from WordPress that the database needs repairs, but all tables are okay.
I found, that the wp_options table was not restored entirely, so the siteurl and other important settings are missing. In the log I find this message:
An error (1) occurred: The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size. – SQL query was (type=3): INSERT INTO wp_options VALUES (1, ‘siteurl’,
It occured on a client’s site who is running on cloudways. I tried to replicate the problem on my local WAMP site and got the same error. I tried to increase the innodb_log_file_size from 5M to 32M but this did not fix the issue.
Can anybody help?
January 12, 2018 at 6:33 pm #254655Dee NutbourneModeratorHi,
Please could you send us a copy of the restoration log?
This can be found in the ‘wp-content/updraft’ directory of the site via FTP.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 link here.
Best Wishes,
David NJanuary 12, 2018 at 7:46 pm #254670a.weimannParticipantHi please find the log file here: https://www.dropbox.com/s/6euf5tu5nqilkif/log.08db555beed2.txt?dl=0
Thanks for helping!
Best
AndreasJanuary 12, 2018 at 7:55 pm #254677a.weimannParticipantFirst logfile was from local server, this one is from webserver: https://www.dropbox.com/s/1wh2a66grwtvn48/log.b9c6e5cefc09.txt?dl=0
Best,
AndreasJanuary 16, 2018 at 11:57 am #255323Dee NutbourneModeratorHi Andreas,
Apologies for the delay.
Please could you ‘innodb_log_file_size’ to 128M?
After changing this, you will need to follow these steps to apply the changes:- Shutdown the server
- Move away the log files (named ib_logfile0, ib_logfile1, etc.)
- Restart the server. New log files should be generated
You can then repeat the restoration.
Best Wishes,
David N -
AuthorPosts
- The topic ‘Cannot restore database from backup’ is closed to new replies.