Re: mysql 4 > 5 export import issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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@icq
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos

[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux