Hi Mike, I hope you are on linux machine, What are versions on old and new machines, is there any difference?.
just tar the data dir /var/lib/mysql (in most of the cases) and untar on the new machines by moving the existing mysql directory by this old data. I don't think this will fail, I have done this procedure many times for the same versions, but never tried with different versions. regards, Praveen --- Mike Hillyer <[EMAIL PROTECTED]> wrote: > 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 > __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com --------------------------------------------------------------------- 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
