Sent: Monday, July 30, 2007 7:20 PM
Subject: Re: Best way to backup three live databases
Hi,
The best two suggestions I can give you are LVM snapshots for binary
backups, or using replication so you can back up the slave. Since you
have InnoDB tables, my personal opinion is the safest way to ge
Hi,
The best two suggestions I can give you are LVM snapshots for binary
backups, or using replication so you can back up the slave. Since you
have InnoDB tables, my personal opinion is the safest way to get a good
LVM snapshot is to shut down the server and take the snapshot; you can
then b
We've got a production system with three databases. The three databases
together represent one logical set of data. The databases contain a
mixture of MyISAM and InnoDB tables.
What is the best way to backup the entire system (i.e. all three
databases) to ensure that I get a coherent snapshot of
