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
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博客 ” ，链接：https://blog.itpub.net/29620572/viewspace-1735082/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
