#! /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