Re: moving DB from one box to another.

2004-12-16 Thread William R. Mussatto
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.

Re: moving DB from one box to another.

2004-12-16 Thread Ian Sales
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

RE: moving DB from one box to another.

2004-12-15 Thread Randy Paries
: 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

Re: moving DB from one box to another.

2004-12-15 Thread Paul DuBois
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