shell中备份web站点及数据库

aa

备份web站点及数据库

#!/bin/bash

MYSQL_USER=root
MYSQL_PASS=admin
DB_NAME=cacti
WEB_DATA=/var/www/html
WEB_BACKUP=/backup/cacti/

DataBakName=Data_$DB_NAME_$(date +"%Y%m%d").tar.gz
WebBakName=Web_$DB_NAME_$(date +%Y%m%d).tar.gz
OldData=Data_$DB_NAME_$(date -d -14day +"%Y%m%d").tar.gz
OldWeb=Web_$DB_NAME_$(date -d -14day +"%Y%m%d").tar.gz

#备份数据库和web目录
/usr/bin/mysqldump -u$MYSQL_USER -p$MYSQL_PASS -B ${DB_NAME} | gzip -9 > $WEB_BACKUP${DataBakName}
/usr/bin/tar zcfP ${WEB_BACKUP}$WebBakName $WEB_DATA

#删除指定日期以前的文件
rm -rf ${WEB_BACKUP}${OldData} ${WEB_BACKUP}${OldWeb}