Mysterious duplicate entry error for key from MySQL Backup

[Mathis Neumann]

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: http://justpaste.it/177n

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


Thanks,
Mathis



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