[TriLUG] back up your $HOME

[Michael Peters]

On 05/27/2011 10:35 AM, Magnus wrote:

> If you'd rather just back up the db files, with an outage window of seconds you could stop the DB, take an LVM snapshot, and start the DB again. Then take your good old time backing up the files on the snapshot.

It's better not to stop mysql completely, but just lock it against 
writes. This has a couple of advantages: 1) client programs can still 
read data from mysql, they just can't change it 2) it's faster to 
release a lock than it is to restart mysql so your downtime is less

   FLUSH TABLES WITH READ LOCK

-- 
Michael Peters
Plus Three, LP