#! \/bin\/bash
\nDB_USER=”root”
\nDB_PASS=”root”
\nBIN_DIR=”\/usr\/bin”
\nBACK_DIR=”\/data\/backdata”
\nDATE=”mysql-`date +’%Y%m%d-%H:%M:%S’`”
\nLogFile=”$BACK_DIR”\/dbbakup.log
\n#\u65e5\u5fd7\u8bb0\u5f55\u4fdd\u5b58\u7684\u76ee\u5f55
\nBackNewFile=$DATE.sql
\n$BIN_DIR\/mysqldump –single-transaction –flush-logs –all-databases –master-data \u00a0-u$DB_USER \u00a0-p$DB_PASS > $BACK_DIR\/$DATE.sql
\necho ———-“$(date +”%y-%m-%d %H:%M:%S”)”———— >> $LogFile
\necho \u00a0createFile:”$BackNewFile” >> $LogFile
\n#find “\/data\/backdata\/” -cmin +1 -type f -name “*.sql” -print > deleted.txt
\nfind “\/data\/backdata\/” -ctime +7 -type f -name “*.sql” -print > deleted.txt
\necho -e “delete files:\\n” >> $LogFile
\n#\u5faa\u73af\u5220\u9664\u5339\u914d\u5230\u7684\u6587\u4ef6
\ncat deleted.txt | while read LINE
\ndo
\nrm -rf $LINE
\necho $LINE>> $LogFile
\ndone
\necho “—————————————————————” >> $LogFile<\/p>\n","protected":false},"excerpt":{"rendered":"