Is there a reason this wouldn't work with InnoDB? (I understand
there's usually a single ibdata file, but so?)
On Jan 24, 2008, at 8:08 AM, Matthias Witte wrote:
On Thu, Jan 24, 2008 at 01:42:38PM +0200, Ivan Levchenko wrote:
Hi All,
What would be the best way to transfer a 20 gig db from one host to
another?
If it consists of MyISAM tables you can do a pre rsync with everything
up and running.
Then you would lock all tables and do the real sync[1] while the
lock is in
operation.
You can then do the switchover or start the replication or whatever
you
want to do and unlock all tables.
I do not know any way, how to evade the locking, besides recording all
changes while the transfer is in progress and adding these to the new
database later.
[1] If you rsync over ssh, you should use ssh options "-C -cblowfish".
Mit freundlichem Gruß,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]