Re: better way to backup 50 Gig db?

[Jay Ess]

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.