MySQL Forums
Forum List  »  Newbie

Loading data into 5.5.16 dumped from 5.0.26
Posted by: Sukhbir Singh
Date: January 16, 2012 09:28AM

Hello,

I have 2 MySQL servers one running 5.0.26 and other runnning 5.5.16. Both on the Linux servers. I am extracting data using mysqldump on 5.0.26 and trying to load it into 5.5.16. I am getting the below error:

ERROR 1062 (23000) at line 3690: Duplicate entry 'weiÃe' for key 'PRIMARY'

On both the servers the character set is "utf8". The table has a primary key for this column on the Source DB. So logically it shouldn't cause any issue loading into the Target DB.

Can somebody please help with this?

Thanks
SS

Options: ReplyQuote


Subject
Written By
Posted
Loading data into 5.5.16 dumped from 5.0.26
January 16, 2012 09:28AM


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.