Sorry, When I do the mysql dbname < oldbox.sql
I get the error message It creates mysqldump dbname -h oldbox > oldbox.sql fine Thanks -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 11:25 PM To: Randy Paries; [EMAIL PROTECTED] Subject: Re: moving DB from one box to another. At 23:21 -0600 12/15/04, Randy Paries wrote: >hello, >I have built a new DB box. >Orig db is mysqld Ver 3.23.58 >New DB is mysqld Ver 4.0.20 >I want to move the data from one box to another. >I have a couple of really large tables with longtext fields. This data >is a bunch of HTML My plan was to do a mysqldump dbname -h oldbox > >oldbox.sql then do a mysql dbname < oldbox.sql > >The problem is I get this wonderfully verbose :-( error message >:::ERROR at line 362701 It might help to specify at which point in this process the error occurs. During the dump? During the reload? > >I am wondering if there is some single quotes that may be messing it up >or something like. > >What is the best way to do this? > >Thanks -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]