Problem uploading backup .sql ?

  • Thermoses

    (@thermoses)


    13 years ago

    I am getting this error and am stumped. I tried emptying my tables before import but still can not get it to work. Any ideas? Should I delete all tables then upload?

    ERROR

    SQL query:

    CREATE TABLE wp_commentmeta (

    meta_id BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
    comment_id BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT ‘0’,
    meta_key VARCHAR( 255 ) DEFAULT NULL ,
    meta_value LONGTEXT,
    PRIMARY KEY ( meta_id ) ,
    KEY comment_id ( comment_id ) ,
    KEY meta_key ( meta_key )
    ) ENGINE = MYISAM AUTO_INCREMENT =211 DEFAULT CHARSET = utf8;

    MySQL said:

    #1050 – Table ‘wp_commentmeta’ already exists

Viewing 2 replies - 1 through 2 (of 2 total)
  • essaysnark

    (@essaysnark)

    13 years ago

    I am no DB expert but whenever I’ve tried restoring from a backup, I’ve always dropped all the tables and then done the import. I think it might depend on how the SQL import file was constructed though doesn’t it? I get scared with this stuff… 🙂 but FWIW the process I did previously was drop all tables and then import the file.

    My host has an excellent tutorial on this stuff: http://support.wpengine.com/importing-your-database/

    Thread Starter Thermoses

    (@thermoses)

    13 years ago

    THx…worked great!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Problem uploading backup .sql ?’ is closed to new replies.

Tags