Cannot restore database from backup

  • Resolved Marian Heddesheimer

    (@heddesheimer)


    6 years, 10 months ago

    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?

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    Please could you send us a copy of the full 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,
    Bryle

Viewing 1 replies (of 1 total)
  • The topic ‘Cannot restore database from backup’ is closed to new replies.

Tags