求debian vps下自动备份脚本 - 全球主机交流论坛

#!/bin/bash

#Funciont: Backup website and mysql database
#Author: licess
#Website: http://lnmp.org

#IMPORTANT!!!Please Setting the following Values!
bak_dir=/home/backup
if [ -d $bak_dir ]; then
echo 'begin'
else
mkdir $bak_dir
fi

######~Set MySQL UserName and password~######
MYSQL_UserName=用户名
MYSQL_PassWord=密码

######~Set MySQL Database you want to backup~######
Backup_DB=('数据库1' '数据库2' '数据库3')

TodayWWWBackup=www-*-$(date +"%Y-%m-%d").tar.gz
TodayDBBackup=db-$(date +"%Y-%m-%d").tar.gz
OldWWWBackup=www-*-$(date -d -3day +"%Y-%m-%d").tar.gz
OldDBBackup=db-$(date -d -3day +"%Y-%m-%d").tar.gz

ls -l /home/wwwroot/ | grep "^d" | awk {'print $9'} | xargs -i tar czf $bak_dir/www-{}-`date +%Y-%m-%d`.tar.gz -C /home/wwwroot/ {}

for item in ${Backup_DB[@]};do
/usr/local/mysql/bin/mysqldump -u$MYSQL_UserName -p$MYSQL_PassWord $item > $bak_dir/db-$item-$(date +"%Y-%m-%d").sql
done

cd $bak_dir
tar zcf $bak_dir/$TodayDBBackup db-*-$(date +"%Y-%m-%d").sql

rm -f $bak_dir/db-*-$(date +"%Y-%m-%d").sql
rm -f $bak_dir/$OldWWWBackup
rm -f $bak_dir/$OldDBBackup