mysql 备份 rsync

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