• Resolved bertiebubblehead

    (@bertiebubblehead)


    I am sure I am doing something stupid but when I try to use Phpmyadmin to restore my database files saved to Dropbox I get an error message.
    I have deleted all the tables in the new database and also created a completely new database to no avail. I have a very limited amount of tech knowledge and would appreciate any help you can give. A great program all the same.
    This is the error message I get
    Error
    SQL query:


    — Create and use the backed up database


    — Table structure for table Truewp_users

    CREATE TABLE truewp_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 =5 DEFAULT CHARSET = utf8;

    MySQL said:

    #1050 – Table ‘truewp_users’ already exists

    http://ww.wp.xz.cn/extend/plugins/wordpress-backup-to-dropbox/

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

The topic ‘Apparent error in my backup database files’ is closed to new replies.