On Thu, Oct 30, 2008 at 9:52 AM, Karanbir Singh <span dir="ltr">&lt;<a href="mailto:mail-lists@karan.org">mail-lists@karan.org</a>&gt;</span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">Tom Brown wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

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<br>
<br>
<br>
</blockquote>
<br>
i am changing the actual box so i have to dump and then import as i am also moving from centos4 to 5 -<br>
</blockquote>
<br></div>
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.<br>
</blockquote></div><br>But make sure mysqld is not running on either box when doing it this way.&nbsp; Also, if you have any innodb tables you must have the exact same innodb settings in your /etc/my.cnf<br clear="all"><br>-- <br>
-matt<br>