Title: Duplicate entry when importing database Last modified: August 19, 2016 --- # Duplicate entry when importing database * [jnavia](https://wordpress.org/support/users/jnavia/) * (@jnavia) * [17 years, 9 months ago](https://wordpress.org/support/topic/duplicate-entry-when-importing-database/) * I exported a database last night, then upgraded to 2.6.1 (don’t know if the subsequent upgrade has anything to do with the error. I doubt it, but thought I’d mention it). (I needed to reinstall using Simple Scripts — I’ve been attacked too many times by hackers). * Importing the databases using phpMyAdmin gets me Duplicate entry ‘3’ for key 1 error (see full error message below) every time I try. * I’ve already read [http://wordpress.org/support/topic/137063?replies=17](http://wordpress.org/support/topic/137063?replies=17)( several times!). All IDs have auto-increments. I’ve searched the forums for the past couple hours. * Tried deleting the particular comments from the SQL table, but continue to get the error messages. Deleted the whole database and tried installing again, get the same message. * Anyone have any idea what I can try next? * Error * SQL query: * — — Dumping data for table `wp_comments` — INSERT INTO `wp_comments` (`comment_ID`,` comment_post_ID`, `comment_author`, `comment_author_email`, `comment_author_url`,` comment_author_IP`, `comment_date`, `comment_date_gmt`, `comment_content`, `comment_karma`,` comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`) VALUES (3, 8, ‘Jeanette’, ”, ‘[http://marfanlife.net/jet’](http://marfanlife.net/jet’);,‘ 206.246.248.127’, ‘2006-06-15 00:21:40’, ‘2006-06-15 00:21:40’, ‘I called CIC CI, and they said they would reimburse me. We”ll see.’, 0, ‘1’, ‘Mozilla/5.0 ( Windows; U; Windows NT 5.1; en-US; rv:1.8b4) Gecko/20050908 Firefox/1.4’, ”, 0, 1), (7, 28, ‘Dad’, ”,”, ‘207.69.137.40’, ‘2006-06-20 13:36:55’, ‘2006-06-20 13:36:55’, ‘Remember, I told you that a robin built a nest on top of my mourning dove”s nest? Those baby robins (3)flew away last week–I hope. Anyway, I saw no little piles of feathers in the yard. I wonder what the mourning dove[…] * MySQL said: Documentation #1062 – Duplicate entry ‘3’ for key 1 Viewing 2 replies - 1 through 2 (of 2 total) * Thread Starter [jnavia](https://wordpress.org/support/users/jnavia/) * (@jnavia) * [17 years, 9 months ago](https://wordpress.org/support/topic/duplicate-entry-when-importing-database/#post-838324) * Just to make sure, I re-installed version 2.6.0 and still got the same problem when I tried to import my database. * [pswish_themes](https://wordpress.org/support/users/pswish_themes/) * (@pswish_themes) * [17 years, 1 month ago](https://wordpress.org/support/topic/duplicate-entry-when-importing-database/#post-838654) * I get the same error and I’d be grateful if anyone can post an idea here.. Viewing 2 replies - 1 through 2 (of 2 total) The topic ‘Duplicate entry when importing database’ is closed to new replies. ## Tags * [sql-error](https://wordpress.org/support/topic-tag/sql-error/) * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 2 replies * 2 participants * Last reply from: [pswish_themes](https://wordpress.org/support/users/pswish_themes/) * Last activity: [17 years, 1 month ago](https://wordpress.org/support/topic/duplicate-entry-when-importing-database/#post-838654) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics