[TriLUG] back up your $HOME

Magnus magnus at trilug.org
Fri May 27 10:35:06 EDT 2011


On May 27, 2011, at 10:24 AM, Alan Porter wrote:
> 
> I do a mysqldump and back that up.  It dumps all of the
> table data to ready-to-import SQL statements in a text
> file.


For anyone thinking of going this route:

http://provenscaling.com/blog/2008/10/19/how-mysqldump-locks-tables-with-different-options/

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.

-M




More information about the TriLUG mailing list