MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

Re: Mysterious duplicate entry error for key from MySQL Backup
Posted by: Ravi Thati
Date: August 21, 2012 10:39PM

Possible cause:

Do you have any triggers on any table that operates on second table while inserting into one table? If yes, during restore this might be causing duplicate error during restore.

If doing restore to same server, drop the table/database properly.


As Rick said, getting the complete options used for mysqldump would give more info.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Mysterious duplicate entry error for key from MySQL Backup
5059
Mathis Neumann
August 07, 2012 11:42PM
Re: Mysterious duplicate entry error for key from MySQL Backup
1835
Rick James
August 19, 2012 09:23PM
Re: Mysterious duplicate entry error for key from MySQL Backup
1868
Eric Backer
August 21, 2012 10:30AM
Re: Mysterious duplicate entry error for key from MySQL Backup
2077
Eric Backer
August 21, 2012 10:28AM
Re: Mysterious duplicate entry error for key from MySQL Backup
1970
Ravi Thati
August 21, 2012 10:39PM
Re: Mysterious duplicate entry error for key from MySQL Backup
2270
Bill Swartz
August 24, 2012 09:33AM
Re: Mysterious duplicate entry error for key from MySQL Backup
1673
Eric Backer
September 12, 2012 08:43AM


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.