FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > CentOS > CentOS

 
 
LinkBack Thread Tools
 
Old 10-30-2008, 12:14 PM
Tom Brown
 
Default mysql 4 > 5 export import issue

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

_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
 
Old 10-30-2008, 12:22 PM
Karanbir Singh
 
Default mysql 4 > 5 export import issue

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@centos.org
http://lists.centos.org/mailman/listinfo/centos
 

Thread Tools




All times are GMT. The time now is 05:12 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org