Re: [CentOS] mysql 4 > 5 export import issue

Hi,

On Thu, Oct 30, 2008 at 09:14, Tom Brown tom@ng23.net wrote:

I am migrating a mailserver from CentOS 4 to 5 and i am migrating the db's over from mysql-max-4.1.13 to mysql-server-5.0.45-7.el5 during the mysql import it fails with this... ERROR 1062 (23000) at line 129: Duplicate entry '3-r��?�' for key 1

The characters look binary, so this might be a problem of conversion latin1 -> utf8 or vice versa.

Try dumping with:

mysqldump --default-character-set=binary ... >/path/to/dumpfile

And loading the dump with:

mysql --default-character-set=binary ... >/path/to/dumpfile

Let us know if that works.

HTH, Filipe