WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Error restoring from WPB2Dropbox backup (3 posts)

  1. david90403
    Member
    Posted 1 year ago #

    Hello, we use WP Backup to Dropbox to backup our website. I am trying to upload the backup_core sql file to PHP myadmin but I get the following error message.

    SQL query:

    --
    -- Table structure for table wp_6dye9t_users
    --
    CREATE TABLE wp_6dye9t_users (

    ID BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
    user_login VARCHAR( 60 ) NOT NULL DEFAULT '',
    user_pass VARCHAR( 64 ) NOT NULL DEFAULT '',
    user_nicename VARCHAR( 50 ) NOT NULL DEFAULT '',
    user_email VARCHAR( 100 ) NOT NULL DEFAULT '',
    user_url VARCHAR( 100 ) NOT NULL DEFAULT '',
    user_registered DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    user_activation_key VARCHAR( 60 ) NOT NULL DEFAULT '',
    user_status INT( 11 ) NOT NULL DEFAULT '0',
    display_name VARCHAR( 250 ) NOT NULL DEFAULT '',
    PRIMARY KEY ( ID ) ,
    KEY user_login_key ( user_login ) ,
    KEY user_nicename ( user_nicename )
    ) ENGINE = MYISAM AUTO_INCREMENT =16 DEFAULT CHARSET = utf8;

    MySQL said:

    #1050 - Table 'wp_6dye9t_users' already exists

    Is there an easy way for me to fix this so I can restore the website? The restoring your database page suggesting posting here if I get an error.

    Thanks in advance!

  2. DJDoubleXL189
    Member
    Posted 1 year ago #

    If the table already exists, your import isn't going to overwrite it. Backup the latest table, delete it, then import what you're going to import.

  3. david90403
    Member
    Posted 1 year ago #

    Thanks, I am uploading the backup.

Topic Closed

This topic has been closed to new replies.

About this Topic