Thanks Everybody for your help! I'll think over what would be the best in my situation...
/me hoping to add a success story to this thread later On Jan 24, 2008 3:08 PM, Matthias Witte <[EMAIL PROTECTED]> 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ß, > > -- > 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] > > -- Best Regards, Ivan Levchenko [EMAIL PROTECTED]
