#數(shù)據(jù)庫(kù)定時(shí)備份#備份路徑BACKUP=/data/backup/db#獲取當(dāng)前時(shí)間作為文件名DATETIME=$(date +%Y_%m_%d_%H%M%S)echo “=開始備份=”echo ‘備份的路徑是 BACKUP/BACKUP/BACKUP/DATETIME.tar.gz'#主機(jī)HOST=localhost#用戶名DB_USER=rootDB_PWD=rootDATABASE=myDB#創(chuàng)建備份路徑[ ! -d “BACKUP/BACKUP/BACKUP/DATETIME” ] && mkdir -p “BACKUP/BACKUP/BACKUP/DATETIME”#執(zhí)行mysql的備份數(shù)據(jù)庫(kù)的指令mysqldump -uDBUSER−p{DB_USER} -pDBU​SER−p{DB_PWD} --host=$HOST $DATABASE | gzip > BACKUP/BACKUP/BACKUP/DATETIME/$DATETIME.sql.gz#打包備份文件cd $BACKUPtar -zcvf $DATETIME.tar.gz $DATETIME#刪除臨時(shí)目錄rm -rf BACKUP/BACKUP/BACKUP/DATETIME#刪除10天之前的備份文件find $BACKUP -mtime +10 -name “*.tar.gz” -exec rm -rf {} ;echo “備份成功”