Cannot import backed up database

  • Resolved jgold723

    (@jgold723)


    6 years, 1 month ago

    I’m trying to restore a database backed up by Updraft Plus. I’m not using the restore function, as I can’t get into the site now, but I’ve created a new database and I’m trying to import the Updraft Plus DB into it.

    When I do, it gets part way through the process then fails with this error:

    #1062 – Duplicate entry ‘_transient_tw_requirements_check’ for key ‘option_name’ intext:”Plugin: UpdraftPlus WordPress Backup Plugin”

    Any idea what this means and is there a way around it?

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author David Anderson

    (@davidanderson)

    Does that happen every time? If so, the source database is corrupt, and will need manually editing in a text editor to remove the duplicate entry before restoring it.

    David

    Thread Starter jgold723

    (@jgold723)

    So is this a bug in Updraft Plus? I’ve been thinking about upgrading to premium, but I’m concerned if it isn’t creating reliable files.

    FYI: I was able to restore the full site via Updraft Plus using my full Updraft Plus file package. However, I noticed in the restore log the same error:

    ‘Processing table (MyISAM): wp_options – will restore as: wpgy_options
    An error (1) occurred: – Duplicate entry ‘_transient_tw_requirements_check’ for key ‘option_name’ – the database query being run was: INSERT INTO wpgy_options VALUES (258376, ‘wpseo_sitemap_11702_cache_validator’, ‘5ebvT’, ‘no’),

    Somehow Updraft Plus worked around it, but I’m curious to know if this is a bug, or whether Updraft Plus files only work with Updraft Plus?

    Plugin Author David Anderson

    (@davidanderson)

    So, the first time you were using mysql from the command-line, or something like that?

    The difference is just that the default mode of whatever tool you were using was to stop upon errors, whereas UD continues. In this case, the error is inconsequential, as WP transient data by definition is data that does not matter if it does not exist.

    David

    Thread Starter jgold723

    (@jgold723)

    Ah, good to know. Thanks for the explaination!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Cannot import backed up database’ is closed to new replies.