Hi, Some of the old mysqldump apps have a bug where they're missing quotes on long rows. Try the dump the other way - i.e. use the mysqldump client on the new machine and pipe it from the old machine back to the new machine (make sure the new machine has permissions to grab from the old one...). With something like:
> mysqldump -h oldmachine -u username olddatabase | mysql newdatabasename Cheers, Andrew Sql,query -----Original Message----- From: Mike Hillyer [mailto:[EMAIL PROTECTED]] Sent: Friday, 04 October 2002 01:25 To: MySQL Mailing List Subject: Problem with moving database using mysqldump Hello All; I am having a problem using the mysqldump application. I have an old server that I am trying to move to a faster machine. No matter what I do, about 90 queries in the connection ceases and the old meachine gets a server has gone away error. I have tries runnig mysql dump piped to the mysql client on the old machine with the client connecting across the network and on the new machine with mysqldump connecting across the network. I have also tried producing a file and then piping the file into mysql client on the new machine, but no success, always the new machine stops processing requests around the 90-100 query mark. Does anyone have any idea why this is happening? The file is about 40-50MB and the largest table in the database is only 110,000 rows, so this should not be straining the system. Thanks, Mike Hillyer --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
