Support » Installing WordPress » 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 (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?


    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’, ”, ‘’, ‘’, ‘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’, ”,”, ‘’, ‘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)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Duplicate entry when importing database’ is closed to new replies.