Restore my database, Duplicate Key MySQL?

  • Resolved VivBounty

    (@vivbounty)


    13 years, 10 months ago

    Hi I’m getting this error. No idea how to remove the duplicate key. Will not restore my database. Can anyone help?

    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 (5, 1, ‘VivBounty’, ‘vivbounty@gmail.com’, ”, ‘156.34.41.87’, ‘2009-11-18 13:49:17’, ‘2009-11-18 17:49:17’, ‘Jim Stone, I thank you for being my first commentator on my new pet blog. So glad you like it. I am very happy with it too.\r\n\r\nThank you Crystal Spring for your comment and for keeping up with my blog. I hope you find the products as effective as I do!\r\n\r\nTrudyVan thank you for your comment. I do know that you love your pets. That is why I just had to put your parrot blog on my blogroll.’, 0, ‘1’, ‘Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/3.0.195.33 Safari/532.0’, ”, 0,[…]

    MySQL said: Documentation
    #1062 – Duplicate entry ‘5’ for key 1

    I read somewhere that each table has a key and you can’t import another key but I know NOTHING
     about mySQL.

    Would humbly appreciate any help anyone can offer.

    Thank you advance,
    Viv

Viewing 2 replies - 1 through 2 (of 2 total)
  • threestyler

    (@threestyler)

    13 years, 10 months ago

    Assuming your trying to upload a database backup? If so and you definitely have a db backup then try dropping all the tables from phpmyadmin then re uploading the sql backup.

    Or open the backup sql file and append “INSERT INTO” with:

    http://wordpress.pastebin.com/Z4RY9Fza

    Thread Starter VivBounty

    (@vivbounty)

    13 years, 10 months ago

    Oh thank you so much for replying threestyler. I have been in such a state with this, so panicked.

    Yes I do have a db backup. I dropped the table and all restored. Thank you so much. OMG it worked!!

    You are a lifesaver, threestyler!!

    Prosperous Blessings with humble gratitude.

    Viv

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Restore my database, Duplicate Key MySQL?’ is closed to new replies.