mysql增量恢复脚本

#!/bin/sh
bindir="/data/mysql/bin/"
binlogdir="/backup"
username="root"
passd="wanyin"
sock="/data/mysql/data/mysqld-3304.sock"
for filename in $(ls -l ${datadir}mysql-bin.[0-9]* | awk '{print $9}')
do
${bindir}mysqlbinlog -d wy_sso --base64-output=decode-rows -v  $filename | ${bindir}mysql -u${username} -p${passd} --socket=${sock} >log.txt 2>log.err
  if [ "$?" -eq 0 ] ; then
   echo "${filename} has been recovered."
  else
   echo "${filename} has not been completed"
   break
  fi
done

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29620572/viewspace-1735082/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29620572/viewspace-1735082/