Error when importing database

  • Skunky

    (@skunky)


    11 years, 5 months ago

    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.

    (@clorith)

    11 years, 5 months ago

    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.