MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

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?

Regards,
Yasir

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


Subject
Views
Written By
Posted
ERROR 1062 (23000): Duplicate entry
7946
Mohammed Yasir Hashmi
March 07, 2017 03:07AM
Please do not post the same question in multiple forums
947
Peter Brawley
March 07, 2017 05:55AM
Re: ERROR 1062 (23000): Duplicate entry
1543
Eric Fernandez
June 01, 2017 11:11AM
Re: ERROR 1062 (23000): Duplicate entry
1039
Peter Brawley
June 01, 2017 12:18PM


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.