Title: Error when importing database
Last modified: August 22, 2016

---

# Error when importing database

 *  [Skunky](https://wordpress.org/support/users/skunky/)
 * (@skunky)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/error-when-importing-database/)
 * Hi,
 * because I thought someone hacked into my database I tried to import an earlier
   back-up I made, to the existing database.
    I get the following error: It’s in
   Dutch sorry, hope anyone can help me?
 * Fout
 * SQL-query:
 * —
    — Gegevens worden uitgevoerd voor tabel `wp_claim_ownership` — INSERT INTO`
   wp_claim_ownership` ( `clid` , `post_id` , `post_title` , `user_id` , `full_name`,`
   your_email` , `contact_number` , `your_position` , `author_id` , `status` , `
   comments` ) VALUES ( 1, 125, ‘'Het Zeehaasje' Hans van Woerkom’, 0, ”, ”, ”, ”,‘
   1’, ‘1’, ” ) ;
 * MySQL meldt: Documentatie
    #1062 – Duplicate entry ‘1’ for key 1

Viewing 1 replies (of 1 total)

 *  Moderator [Marius L. J.](https://wordpress.org/support/users/clorith/)
 * (@clorith)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/error-when-importing-database/#post-5662532)
 * Hi,
 * Am I right in presuming that you are trying to just overwrite the existing tables
   when you get this error?
 * If so the problem is that you can’t have duplicate index keys (the first value
   in this case).
 * You can easily solve this by adding `TRUNCATE TABLE wp_claim_ownership` at the
   top of your file, but be aware that **this _will_ remove all content in that 
   table**

Viewing 1 replies (of 1 total)

The topic ‘Error when importing database’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Marius L. J.](https://wordpress.org/support/users/clorith/)
 * Last activity: [11 years, 5 months ago](https://wordpress.org/support/topic/error-when-importing-database/#post-5662532)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics