Hi 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 anyone got any clues to this one as so far i have drawn a blank thanks
Tom Brown wrote:> ERROR 1062 (23000) at line 129: Duplicate entry '3-r????' for key 1 > > anyone got any clues to this one as so far i have drawn a blankyou are inserting multiple duplicate values somewhere where its not allowed. without looking at your schema it would be hard to work out what the issue is. in other news, you dont need to dump + reload when you move from mysql-4 to mysql-5, just service mysqld stop; yum update mysql\*; /usr/bin/mysql_upgrade ; service mysqld start -- Karanbir Singh : http://www.karan.org/ : 2522219 at icq
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 1The 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