#!/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/,如需转载,请注明出处,否则将追究法律责任。