Title: SQL Error When Importing Database
Last modified: August 21, 2016

---

# SQL Error When Importing Database

 *  [alainafrederick](https://wordpress.org/support/users/alainafrederick/)
 * (@alainafrederick)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sql-error-when-importing-database/)
 * I am trying to move a site from one host to another. With the current host I 
   do not have access to the cPanel so I used WP-DB-Backup to create a database 
   file. When I import to our new host I am getting the following error:
 * Error
    SQL query:
 * INSERT INTO `wp_options`
    VALUES ( 2888629, ‘_transient_timeout_wpsc_customer_meta__sQpyQE)
   8XaDM’, ‘1393320664’, ‘no’ ) ;
 * MySQL said: Documentation
 * #1062 – Duplicate entry ‘2888629’ for key ‘PRIMARY’
 * I am unsure what to do at this point? I have tried dumping ALL of the database
   files and starting from an empty database but still a no go.

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

 *  [Forensica Digital](https://wordpress.org/support/users/forensica-digital/)
 * (@forensica-digital)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sql-error-when-importing-database/#post-4642374)
 * Hmmm.. without access to the db can be a bit tricky, have you asked your hosting
   support? maybe they can install your db.
 *  [webbrewers](https://wordpress.org/support/users/webbrewers/)
 * (@webbrewers)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sql-error-when-importing-database/#post-4642386)
 * Or try using the WP export tool.
 *  Thread Starter [alainafrederick](https://wordpress.org/support/users/alainafrederick/)
 * (@alainafrederick)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sql-error-when-importing-database/#post-4642445)
 * I used WP-DB-Backup to export the database. Then on the new host I’m using phpMyAdmin
   import to import the database. I have a number of plugins for shopping cart items
   and I can not lose those settings.
 * “Or try using the WP export tool.”
 * Isn’t that the same as using WP-DB-Backup? If I use export in WordPress and then
   upload it does not bring over all the settings – I tried. I’d have to redo everything
   almost from scratch.
 *  Thread Starter [alainafrederick](https://wordpress.org/support/users/alainafrederick/)
 * (@alainafrederick)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sql-error-when-importing-database/#post-4642446)
 * “Hmmm.. without access to the db can be a bit tricky, have you asked your hosting
   support? maybe they can install your db.”
 * The old host we don’t even want to go to – they are the reason we are switching
   holding everything hostage. Had to fight just to get an FTP login!

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

The topic ‘SQL Error When Importing Database’ is closed to new replies.

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [sql-query](https://wordpress.org/support/topic-tag/sql-query/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 3 participants
 * Last reply from: [alainafrederick](https://wordpress.org/support/users/alainafrederick/)
 * Last activity: [12 years, 2 months ago](https://wordpress.org/support/topic/sql-error-when-importing-database/#post-4642446)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics