MySQL Forums
Forum List  »  Backup

Mysterious duplicate entry error for key from MySQL Backup
Posted by: Mathis Neumann
Date: August 07, 2012 11:42PM

Hello everyone,
I hava a mayor issue with an import of a MySQL backup. It from a large shop system with about 5000-6000 Products and 1500 Categories.
I created the backup via mysqldump some weeks ago it was on an older, very buggy server, so we decided to resetup the server completely.

The Problem is that I get several duplicate entry for key XX errors when I want to import the backup sql file. For example:
ERROR 1062 (23000) at line 26: Duplicate entry '4-4243' for key 'UNQ_CAT_PRD_LNK_ATTR_INT_PRD_LNK_ATTR_ID_LNK_ID'

I managed to break it down to 4 tables that don't work.
Here is one pasted:

I would really appreciate your help. I tried a lot and this haunts me in the night for almost two weeks now...


Edited 2 time(s). Last edit at 08/07/2012 11:49PM by Mathis Neumann.

Options: ReplyQuote

Written By
Mysterious duplicate entry error for key from MySQL Backup
August 07, 2012 11:42PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.