Title: reinstall database – getting error
Last modified: August 20, 2016

---

# reinstall database – getting error

 *  [kevbikemad](https://wordpress.org/support/users/kevbikemad/)
 * (@kevbikemad)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/reinstall-database-getting-error/)
 * 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)

 *  [Christine Rondeau](https://wordpress.org/support/users/crondeau/)
 * (@crondeau)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/reinstall-database-getting-error/#post-2571772)
 * If you want to re-create a table, you need to drop it first.
 *  Thread Starter [kevbikemad](https://wordpress.org/support/users/kevbikemad/)
 * (@kevbikemad)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/reinstall-database-getting-error/#post-2571808)
 * 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.
 *  [Christine Rondeau](https://wordpress.org/support/users/crondeau/)
 * (@crondeau)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/reinstall-database-getting-error/#post-2571925)
 * > 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

 * [database](https://wordpress.org/support/topic-tag/database/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [Christine Rondeau](https://wordpress.org/support/users/crondeau/)
 * Last activity: [14 years, 3 months ago](https://wordpress.org/support/topic/reinstall-database-getting-error/#post-2571925)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics