A binary copy will require that you shut down the db, rather than just
lock some tables for a while, which may be more desirable.
I've always found the mysql compression to be a bit weak over a slow
link. The way I tend to do this sort of thing is:
mysqldump --opt -B dbname | bzip2 -9c | ssh [EMAIL PROTECTED] 'cat - | bzip2
-9dc | mysql -uwhatever etc'
assuming of course that you have nice fast processors and horrible
slow connectivity (gzip, and something less severe than 9 would do
almost as well)
simon
Simon Elliston Ball
[EMAIL PROTECTED]
On 24 Jan 2008, at 12:20, Saravanan wrote:
do binary copy. sql dump will be slow.
Saravanan
--- On Thu, 1/24/08, Ivan Levchenko <[EMAIL PROTECTED]> wrote:
From: Ivan Levchenko <[EMAIL PROTECTED]>
Subject: transfer huge mysql db
To: mysql@lists.mysql.com
Date: Thursday, January 24, 2008, 6:12 PM
Hi All,
What would be the best way to transfer a 20 gig db from one
host to another?
Thanks in advance for your answers!
--
Best Regards,
Ivan Levchenko
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
