[CentOS] mysql 4 > 5 export import issue
Filipe Brandenburger
filbranden at gmail.com
Thu Oct 30 19:09:32 UTC 2008
Hi,
On Thu, Oct 30, 2008 at 09:14, Tom Brown <tom at 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
More information about the CentOS
mailing list