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