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ß, -- Matthias Witte - [EMAIL PROTECTED] Telefon: +49 (0)211-30 20 33-18 Telefax: +49 (0)211-30 20 33-22 [netzquadrat] GmbH - Gladbacher Str. 74 - 40219 Düsseldorf HRB Düsseldorf 36121 - Geschäftsführer: Thilo Salmon, Tim Mois Steuernummer: 133/5855/0700, Umsatzsteuer-ID: DE199555897 billiger-telefonieren.de - billiger-surfen.de - stromseite.de - sms.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]