RE: (FIXED...)moving DB from one box to another.
Thanks for all your help FYI, I had to add this to the my.cfg set-variable= max_allowed_packet=16M Randy -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 11:55 AM To: [EMAIL PROTECTED] Subject: Re: moving DB from one box to another. Ian Sales said: > Randy Paries wrote: > >> >>The problem is I get this wonderfully verbose :-( error message >>:::ERROR at line 362701 >> >> >> >> > - MySQL can't parse something on line 362701 of your dump file. One > possibility is an index named with a keyword, which 3.23.x appears to > allow but 4.0.x doedsn't. Edit the dump file and see. > > - ian Or it could be that a table name is now a reserved word. DIV in my case -- William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: moving DB from one box to another.
Ian Sales said: > Randy Paries wrote: > >> >>The problem is I get this wonderfully verbose :-( error message >>:::ERROR at line 362701 >> >> >> >> > - MySQL can't parse something on line 362701 of your dump file. One > possibility is an index named with a keyword, which 3.23.x appears to > allow but 4.0.x doedsn't. Edit the dump file and see. > > - ian Or it could be that a table name is now a reserved word. DIV in my case -- William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: moving DB from one box to another.
Randy Paries wrote: The problem is I get this wonderfully verbose :-( error message :::ERROR at line 362701 - MySQL can't parse something on line 362701 of your dump file. One possibility is an index named with a keyword, which 3.23.x appears to allow but 4.0.x doedsn't. Edit the dump file and see. - ian -- +---+ | Ian Sales Database Administrator | | | | eBuyer http://www.ebuyer.com | +---+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: moving DB from one box to another.
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]
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]
moving DB from one box to another.
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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]