Title: Database import error to restore wp database
Last modified: August 20, 2016

---

# Database import error to restore wp database

 *  Resolved [elbriedekock](https://wordpress.org/support/users/elbriedekock/)
 * (@elbriedekock)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-import-error-to-restore-wp-database/)
 * hi,
 * I need some assistance with restoring my database. I made a manual backup, and
   uploaded the backup in phpMyAdmin using “import” button, however got a string
   of errors and need some help to sort out.
 * many thanks.

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

 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-import-error-to-restore-wp-database/#post-3219355)
 * What kinds of errors are you seeing?
 *  Thread Starter [elbriedekock](https://wordpress.org/support/users/elbriedekock/)
 * (@elbriedekock)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-import-error-to-restore-wp-database/#post-3219356)
 * I took a screenshot, [http://dl.dropbox.com/u/64629755/wp-database-import-error.png](http://dl.dropbox.com/u/64629755/wp-database-import-error.png)
 * I made a mistake earlier today to delete a user which had loads of content attached
   to it and didn’t ask to be transferred to another user. I made a manual backup
   a month ago, which I am happy to restore to, but it doesn’t seem to work.
 * I am not technical at all, so struggle to even understand where to look for the
   errors.
 * You’re assistance would be appreciated.
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-import-error-to-restore-wp-database/#post-3219359)
 * Looks like you have an issue with a table for a plugin (bl_instances?). You’d
   need to empty that table before you restore a backup copy.
 *  Thread Starter [elbriedekock](https://wordpress.org/support/users/elbriedekock/)
 * (@elbriedekock)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-import-error-to-restore-wp-database/#post-3219362)
 * how do I empty the table? can’t find bl_instances did you mean blc_instances?
   I have NO CLUE!!
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-import-error-to-restore-wp-database/#post-3219366)
 * > did you mean blc_instances?
 * Sorry – yes.
 *  Thread Starter [elbriedekock](https://wordpress.org/support/users/elbriedekock/)
 * (@elbriedekock)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-import-error-to-restore-wp-database/#post-3219371)
 * OK, so do I just empty the blc_instances table and then try and ‘import’ the 
   backed-up database again?
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-import-error-to-restore-wp-database/#post-3219377)
 * Yes. That should fix that particular error but I’d advise making a backup of 
   your current database before you try anything.
 *  Thread Starter [elbriedekock](https://wordpress.org/support/users/elbriedekock/)
 * (@elbriedekock)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-import-error-to-restore-wp-database/#post-3219392)
 * I had to empty all the tables and then import the database, but it seemed to 
   have done the trick. Thank you very much for your help.
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-import-error-to-restore-wp-database/#post-3219395)
 * No problem. Glad I could help. 🙂

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

The topic ‘Database import error to restore wp database’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 9 replies
 * 2 participants
 * Last reply from: [esmi](https://wordpress.org/support/users/esmi/)
 * Last activity: [13 years, 5 months ago](https://wordpress.org/support/topic/database-import-error-to-restore-wp-database/#post-3219395)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics