[摘要]+-------------------+----------+--------------+------------------+-------------------+3. 释放锁
mysql&...
+-------------------+----------+--------------+------------------+-------------------+
3. 释放锁
mysql> unlock tables;
4. 从快照中备份
# mount -o ro /dev/vg_back/lv-mysql-snap /u01/
# mkdir /backup/`date +%F`
# rsync -a /u01/ /backup/2015-07-02/
5. 移除快照
# umount /u01/
# lvremove -f /dev/vg_back/lv-mysql-snap
脚本 + Cron完成：
#!/bin/bash
#LVM backmysql...
back_dir=/backup/`date +%F`
[ -d $back_dir ] |
关键词： MySQL啥是物理备份（lvm-snapshot）