I'd strongly recommend setting up replication, and then taking your backups from the replica.
mysqlhotcopy works great, I used it for years myself, but it does require "freezing" your database while the copy happens. And no matter how you do it, copying 20 GB takes a little bit of time. Dan On Nov 27, 2007 4:35 PM, David Campbell <[EMAIL PROTECTED]> wrote: > Andras Kende wrote: > > Hi, > > > > What is the preferred way to backup a 20GB database daily, > > without taking offline ? > > > > MySQL 4.1 MyISAM - (will be updated to MySQL 5) > > > > 133 table(s) Sum 115,416,561 latin1_swedish_ci 20.1 GB > > > > Mysqlhotcopy > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
