MySQL Forums :: InnoDB :: ERROR 1062 (23000): Duplicate entry

Advanced Search

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

Subject Views Written By Posted
ERROR 1062 (23000): Duplicate entry 153 Mohammed Yasir Hashmi 03/07/2017 03:07AM
Please do not post the same question in multiple forums 53 Peter Brawley 03/07/2017 05:55AM

Sorry, only registered users may post in this forum.

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.