#! /bin/bash
DB_USER="root"
DB_PASS="root"
BIN_DIR="/usr/bin"
BACK_DIR="/data/backdata"
DATE="mysql-`date +'%Y%m%d-%H:%M:%S'`"
LogFile="$BACK_DIR"/dbbakup.log
#日志记录保存的目录
BackNewFile=$DATE.sql
$BIN_DIR/mysqldump --single-transaction --flush-logs --all-databases --master-data -u$DB_USER -p$DB_PASS > $BACK_DIR/$DATE.sql
echo ----------"$(date +"%y-%m-%d %H:%M:%S")"------------ >> $LogFile
echo createFile:"$BackNewFile" >> $LogFile
#find "/data/backdata/" -cmin +1 -type f -name "*.sql" -print > deleted.txt
find "/data/backdata/" -ctime +7 -type f -name "*.sql" -print > deleted.txt
echo -e "delete files:\n" >> $LogFile
#循环删除匹配到的文件
cat deleted.txt | while read LINE
do
rm -rf $LINE
echo $LINE>> $LogFile
done
echo "---------------------------------------------------------------" >> $LogFile
DB_USER="root"
DB_PASS="root"
BIN_DIR="/usr/bin"
BACK_DIR="/data/backdata"
DATE="mysql-`date +'%Y%m%d-%H:%M:%S'`"
LogFile="$BACK_DIR"/dbbakup.log
#日志记录保存的目录
BackNewFile=$DATE.sql
$BIN_DIR/mysqldump --single-transaction --flush-logs --all-databases --master-data -u$DB_USER -p$DB_PASS > $BACK_DIR/$DATE.sql
echo ----------"$(date +"%y-%m-%d %H:%M:%S")"------------ >> $LogFile
echo createFile:"$BackNewFile" >> $LogFile
#find "/data/backdata/" -cmin +1 -type f -name "*.sql" -print > deleted.txt
find "/data/backdata/" -ctime +7 -type f -name "*.sql" -print > deleted.txt
echo -e "delete files:\n" >> $LogFile
#循环删除匹配到的文件
cat deleted.txt | while read LINE
do
rm -rf $LINE
echo $LINE>> $LogFile
done
echo "---------------------------------------------------------------" >> $LogFile
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28282660/viewspace-1735973/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Linux 文件的压缩
请登录后发表评论
登录
全部评论
