reinstall database – getting error

  • kevbikemad

    (@kevbikemad)


    13 years ago

    I am trying to reinstall a backed up database using phpmyadmin, but I get the following error.

    SQL query:

    CREATE TABLE wp_BWPS_d404 (
    attempt_id bigint( 20 ) NOT NULL AUTO_INCREMENT ,
    computer_id varchar( 20 ) default NULL ,
    attempt_date int( 10 ) default NULL ,
    qstring varchar( 255 ) default NULL ,
    referrer varchar( 255 ) default NULL ,
    PRIMARY KEY ( attempt_id )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1;

    MySQL said: Documentation
    #1050 – Table ‘wp_BWPS_d404’ already exists

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

  • If you want to re-create a table, you need to drop it first.

    Thread Starter kevbikemad

    (@kevbikemad)

    Sorry, I have very limited (no) knowledge about databases. Why would I need to re-create a table if I am trying to basically re-install an entire database?

    I was trying to follow the steps from the codex.

    Login to phpMyAdmin.
    Click databases, and select the database that you will be importing your data into.
    You will then see either a list of tables already inside that database or a screen that says no tables exist. This depends on your setup.
    Across the top of the screen will be a row of tabs. Click the Import tab.
    On the next screen will be a Location of Text File box, and next to that a button named Browse.
    Click Browse. Locate the backup file stored on your computer.
    Make sure the SQL radio button is checked.
    Click the Go button.

    You will then see either a list of tables already inside that database or a screen that says no tables exist.

    Your error says – Table ‘wp_BWPS_d404’ already exists

    Thus the datbase table you are trying to create already exists.

    If you want to create it again, then you need to drop the old one.

    You might want to hire someone to do this for you, if you’re not familiar with databases.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘reinstall database – getting error’ is closed to new replies.

Tags