mysql資料定期備份刪除

標籤：null   date   dev   color   span   eal   article   mysql   dea   

編寫shell指令碼

#!/bin/bash## This is a ShellScript For Auto DB Backup and Delete old Backup#backupdir=/webserver/mysqlbackuptime=` date +%Y%m%d%H `/webserver/software/mysql/bin/mysqldump -u user -ppassword  ybjc | gzip > $backupdir/name$time.sql.gz#deletefind $backupdir -name "name_*.sql.gz" -type f -mtime +5 -exec rm {} \; > /dev/null 2>&1

 

再給shell執行許可權

 

執行crontab -e

 15 11 * * * cd /home/loganalysis/ && ./dealexcel.sh >> /home/loganalysis/error.log 2>&1

 

重啟crontab 

 

參考資料:http://blog.csdn.net/jkunzhang/article/details/7440215

http://blog.csdn.net/a120681076/article/details/51219277

mysql資料定期備份刪除