OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: transfer huge mysql db

From: Chris (dmagickgmail.com)
Date: Tue Jan 29 2008 - 01:01:36 CST


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

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