import database error

  • Hi Friends

    I got a challenge.

    I want to import my DB to live DB, on selecting the DB and clicking import , then I browse to my saved DB, I clicked GO.

    Unfortunately, I got the errors pasted below.

    Error
    SQL query:

    —
    — Database: wordpress
    —
    — ——————————————————–
    —
    — Table structure for table wp_options
    —
    CREATE TABLE wp_options (

    option_id BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
    blog_id INT( 11 ) NOT NULL DEFAULT ‘0’,
    option_name VARCHAR( 64 ) NOT NULL DEFAULT ”,
    option_value LONGTEXT NOT NULL ,
    autoload VARCHAR( 20 ) NOT NULL DEFAULT ‘yes’,
    PRIMARY KEY ( option_id ) ,
    UNIQUE KEY option_name ( option_name )
    ) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1028;

    MySQL said:

    #1050 – Table ‘wp_options’ already exists

    Please I need help on what to do.

    Thanks in advance.

  • The topic ‘import database error’ is closed to new replies.