Issues when restoring DB backup

  • Resolved jmmdigi

    (@jmmdigi)


    1 year, 5 months ago

    I am having issues restoring a database backup using the Updraft plugin. The other backups have restored correctly; I can see all the files when accessing connecting to the server using Filezilla.

    Here are the errors I am getting when trying to restore the DB:

    • This database backup is missing core WordPress tables: terms, term_taxonomy, term_relationships, commentmeta, comments, links, options, postmeta, posts, users, usermeta
    • UpdraftPlus was unable to find any tables when scanning the database backup; it maybe corrupt.

    Just a bit of an insight here, in case it is something obvious I’ve done wrong. I downloaded all the backup files when the site was on an older server and, a week later, I’ve set up the site on a new server and installed Updraft. Then I’ve gone to restore the backup files and the above is occurring for the DB.

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

Viewing 1 replies (of 1 total)

  • Hello,

    Please could you download and extract the database archive on to your desktop, open it in a text editor and look for:

    CREATE TABLE wp_users
    and
    INSERT INTO wp_users

    (enclose the table names with backticks)

    If your prefix is different then substitute wp for the correct one.

    Are these lines present?

    • This reply was modified 1 year, 5 months ago by pbevanudp.
Viewing 1 replies (of 1 total)
  • The topic ‘Issues when restoring DB backup’ is closed to new replies.