MySQL Forums
Forum List  »  InnoDB

ERROR 1062 (23000): Duplicate entry
Posted by: Mohammed Yasir Hashmi
Date: March 07, 2017 03:07AM

Hi All,

Source : 5.6.34 (RHEL 6.6)
Target: 5.6.35 (Windows 12)

We are getting many "ERROR 1062 (23000): Duplicate entry" error while importing a mysqldump export file.
The option used to export the database is :
--routines --single-transaction

I am importing with source command:

mysql>source <path to file>

There are many ERROR 1062 (23000): Duplicate entry errors encountered.

The dump file has create and insert into statements .

I dropped the database and flushed privileges and re-created the database but getting same errors on next import.

Can anybody explain the issue?


Options: ReplyQuote

Written By
ERROR 1062 (23000): Duplicate entry
March 07, 2017 03:07AM

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.