[CentOS] mysql 4 > 5 export import issue

On Thu, Oct 30, 2008 at 9:52 AM, Karanbir Singh <mail-lists at karan.org>wrote:

> Tom Brown 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
>>>
>>>
>>>
>> i am changing the actual box so i have to dump and then import as i am
>> also moving from centos4 to 5 -
>>
>
> rsync or tar the /var/lib/mysql dir up and move that. I am guessing in this
> case that some delimiter is breaking or the dump you did wasent clean.
>

But make sure mysqld is not running on either box when doing it this way.
Also, if you have any innodb tables you must have the exact same innodb
settings in your /etc/my.cnf

-- 
-matt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.centos.org/pipermail/centos/attachments/20081030/2788c598/attachment-0001.html>