[rt-users] Backing up RT

[Andy Graybeal]

> We use mysqldump and logrotate to keep a week of DB dumps on the local
> filesystem, we perform daily backups to a VTL and then tape, and we also
> perform nightly SAN snapshots on the RT host's LUN (making sure to lock
> the databases before the snapshot, and then unlocking after so the MySQL
> DB files are in a consistent state during the snap).

Wow, you have a complicated system.  I was considering backing up the 
whole machine with LVM snapshots, but I don't think I have the space 
overall to deal with full machine snapshots.

If I ever ended up doing LVM snaps, do I need to lock the db first... 
or can I get away with not locking the db with LVM snaps?

You use logrotate to manage your mysqldumps!  Excellent idea.
I need to learn logrotate.  I was wondering how I can keep mysqldumps 
from each day and not lose control of them.  I'm excited.

Thank you for your response.  (I need to google VTL)

-Andy