How to backup mysql database with LVM snapshots:

root@mysqlsrv:~# mysql -u root -p
mysql> flush tables with read lock;
mysql> flush logs;
mysql> quit;

root@mysqlsrv:~# lvcreate --snapshot --size=1000M --name=backupmysql /dev/vg01/mysql

root@mysqlsrv:~# mysql -u root -p
mysql> unlock tables;
mysql> quit;

root@mysqlsrv:~# mkdir -p /backup/mysql
root@mysqlsrv:~# mount -o ro /dev/vg01/backupmysql /backup/mysql
root@mysqlsrv:~# cd /backup/mysql
root@mysqlsrv:~# tar czvf mysql.$(date +"%m-%d%-%Y).tar.gz mysql
root@mysqlsrv:~# umount /backup/mysql
root@mysqlsrv:~# lvremove -f /dev/vg01/backupmysql