[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