> -----Original Message----- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 29, 2008 2:02 AM > To: Ivan Levchenko > Cc: mysql@lists.mysql.com > Subject: Re: transfer huge mysql db > > Ivan Levchenko wrote: > > Hi All, > > > > What would be the best way to transfer a 20 gig db from one host to > another? > > mysqldump -A > file.dump > tar -jcf file.dump > rsync
[JS] You could also just pipe the output of mysqldump through gzip. tar buys you nothing, since it is a single file. > > or use replication to do it (might take a bit longer this way though). > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]