- IT科技
mysql bin日志文件清除sh的实例
时间:2010-12-5 17:23:32 作者:IT科技类资讯 来源:IT科技 查看: 评论:0
内容摘要:复制DELLOG=”/usr/local/logs/del-sqlbin.log.`date+%d`” DELTMP=”/usr/local/logs/del-sqlbin.t

复制DELLOG=”/usr/local/logs/del-sqlbin.log.`date +%d`” DELTMP=”/usr/local/logs/del-sqlbin.tmp” MAIL_ADDR=”xxx@xxx.xx” exec &>$DELLOG DT=`date +’%Y-%m-%d %T’` SINGLE=0 sleep 30 hostname echo `date +’%Y-%m-%d %T’` echo “EXEC>>” echo “PURGE MASTER LOGS BEFORE ‘$DT’;” echo “PURGE MASTER LOGS BEFORE ‘$DT’;” >$DELTMP mysql -uroot -pxxx <$DELTMP if [ $?日志
= 0 ];then echo “Purge master logs sucess!” else echo “Purge master logs failure!” SINGLE=1 fi echo “——————————–” echo if [ $SINGLE = 1 ];then mail -s “Purge_master_logs_err” $MAIL_ADDR <$DELLOG fi 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.