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 [lists@stripped]
Sent: 20 April 2010 09:06
Cc: mysql@stripped
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=1
