Hi, On Thu, Oct 30, 2008 at 09:14, Tom Brown <tom@xxxxxxxx> 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
_______________________________________________ CentOS mailing list CentOS@xxxxxxxxxx http://lists.centos.org/mailman/listinfo/centos
