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, 01:43 PM
"Bart Schaefer"
 
Default mysql 4 > 5 export import issue

On Thu, Oct 30, 2008 at 6:22 AM, Karanbir Singh <mail-lists@karan.org> wrote:
> 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

Theoretically true, but if you ask MySQL.com support they'll tell you
that a dump and restore is advisable. It all depends on which
features you were using. As just one example, if you were relying on
some of the previous auto-update semantics of timestamp columns,
you'll need to alter all the corresponding table definitions manually;
the upgrade process won't do it.
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
 
Old 10-30-2008, 06:09 PM
"Filipe Brandenburger"
 
Default mysql 4 > 5 export import issue

Hi,

On Thu, Oct 30, 2008 at 09:14, Tom Brown <tom@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 1

The 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
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
 
Old 11-03-2008, 08:40 AM
Tom Brown
 
Default mysql 4 > 5 export import issue

The 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,




thanks for all the suggestions - in the end i opted for rsyncing the
datafiles for this db and for me this worked fine. Not the 'correct' way
but one that worked OK at the time.


thanks

_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
 

Thread Tools




All times are GMT. The time now is 09:55 PM.

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