Benjamin Franz wrote: > Something like the following: > > /bin/mkdir /mnt/mysql-snapshot > /sbin/service mysql stop > /usr/sbin/lvcreate --permission r -L16G -s -n dbbackup /dev/mysql/data > /sbin/service mysql start > /bin/mount -r /dev/mysql/data /mnt/mysql-snapshot > /usr/bin/rsync -Saq --delete /mnt/mysql-snapshot /var/lib/mysql-backup/ > /bin/umount /mnt/mysql-snapshot > /usr/sbin/lvremove -f /dev/mysql/data > Whups. I made a serious error with the LVM volumes above. You would end up removing your database partition. Not good. It should read like this: /bin/mkdir /mnt/mysql-snapshot /sbin/service mysql stop /usr/sbin/lvcreate --permission r -L16G -s -n dbbackup /dev/mysql/data /sbin/service mysql start /bin/mount -r /dev/mysql/dbbackup /mnt/mysql-snapshot /usr/bin/rsync -Saq --delete /mnt/mysql-snapshot/ /var/lib/mysql-backup/ /bin/umount /mnt/mysql-snapshot /usr/sbin/lvremove -f /dev/mysql/dbbackup -- Benjamin Franz