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

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 bu

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 a

RE: moving DB from one box to another.

TECTED] 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 tab

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 m

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