I would also recommend looking into some 3rd party tools. http://www.percona.com/docs/wiki/percona-xtrabackup:start - Backup Innodb, MyISAM and XtraDB engines. http://www.maatkit.org/ - Packed with useful features inc a parallel dump/import.
There's some great features in both products. I will leave you to do your own research into the tools as knowing their features will benefit you. Best wishes Andy ________________________________________ From: ext Jay Ess [li...@netrogenic.com] Sent: 20 April 2010 09:06 Cc: mysql@lists.mysql.com Subject: Re: better way to backup 50 Gig db? Gavin Towey wrote: > What Shawn said is important. > > Better options: > 1. Use InnoDB, and then you can make a consistent backup with `mysqldump > --single-transaction > backup.sql` and keep your db server actively > responding to requests at the same time. > > 2. Use something like LVM to create filesytem snapshots which allow you to > backup your database, while only keeping a read lock on the db for a second > or so. > 3. Set up replication and backup the replicated data using any of the above method. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=andrew.2.mo...@nokia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
