[TriLUG] back up your $HOME

Michael Peters mpeters at plusthree.com
Fri May 27 10:44:04 EDT 2011

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


Michael Peters
Plus Three, LP

More information about the TriLUG mailing list