lvm_snapshot.sh

#!/bin/sh

##
# basic script to backup entire drive and backup securely
# backup a mysql database using lvm snapshot tool
##

# stop mysql
/usr/sbin/service mysql stop

# lvm snapshot backup
/sbin/lvcreate -L1G -s -n rootsnapshot /dev/server/root

# restart mysql
/usr/sbin/service mysql start

# mount drives
mount /dev/server/rootsnapshot /mnt
mount /dev/mapper/server-backups /backups

# rotate backup (last 2 days)
find /backups/ -type f -ctime +1 -exec rm -f '{}' \;

# create backup
tar -pczf /backups/`date +"%Y%m%d"`_root.tar.gz /mnt

# umount drives
umount /mnt
umount /backups

# remove snapshot
/sbin/lvremove -f /dev/server/rootsnapshot