[CentOS] mysql 4 > 5 export import issue

Karanbir Singh mail-lists at karan.org
Thu Oct 30 13:22:08 UTC 2008

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 blank

you 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

More information about the CentOS mailing list