1.
/usr/local/mysql/bin/mysql -uroot -ptest -e "stop slave; flush tables with read lock;system /root/test/snap.sh;unlock tables;start slave;"
2. vi /root/test/snap.sh
date
/usr/local/mysql/bin/mysql --socket=/var/mysql.sock -ptest -e "show slave status\G" > /data/shell/logs/`date +"%Y%m%d"`.txt
/sbin/lvcreate -s -n dbsnapshot -L 1G /dev/vg1/lv1
3.
vi /root/shell/dbbackup.sh
date
TODAY=`/bin/date +'%w'`
TODAY1= `expr $TODAY % 7`
/bin/date
mount /dev/vg1/dbsnapshot /dbsnapshot
if [ ! -d /data/shell/$TODAY ]
then
/bin/mkdir /root/shell/$TODAY
else
rm -rf /root/shell/$TODAY
fi
/usr/bin/rsync -av /dbsnapshot/* /root/shell/$TODAY
/bin/umount /dbsnapshot
/sbin/lvremove -f /dev/vg1/snapshot
/bin/date