MySQL-mysqldump backup script

#!/bin/bash################################################################################### purpose:mysqldump script # version:v1.0# date :2013-07-01# author :kin zhang##################################################################################PATH=/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/home/kin/bin:/usr/local/mysql/binexport PATHdatadir=/db/databakdir=/db/backupbakdate=`date +%Y%m%d`if [ -f ${bakdir}/binpos.log ]; then# : #do nothing# flush binlogmysql -uroot -pmysql -e 'flush logs'mysqldump -uroot -pmysql --all-databases > ${bakdir}/${bakdate}_dump.sql# generating the binlog listfind `ls ${datadir}/mysql-bin.0*` -cnewer `cat ${bakdir}/binpos.log`|sed '$d' > ${bakdir}/list.log# copying binlogfor i in `cat ${bakdir}/list.log`docp ${i} ${bakdir}done# record the last binlogls -t ${datadir}/mysql-bin.0*|sed -n '2p' > ${bakdir}/binpos.logelseread -n1 -p "No Backup before,backup right now [Y|N] ?" choicecase $choice inY|y)mysql -uroot -pmysql -e 'flush logs'ls -t ${datadir}/mysql-bin.0* |sed -n '2p' > ${bakdir}/binpos.logmysqldump -uroot -pmysql --all-databases > ${bakdir}/${bakdate}_dump.sql;;N|n)echo "OK,bye"exit 0;;*)echo "Wrong choice,bye"exit 1;;esacfi