自动备份网站

使用crontab和自定义shell进行网站文件和mysql数据库的备份。

crontab -e：

update student step every 0:00
0 0 * * *  curl http://xxx.com/index.php?r=swx/updatestudentstep >/alidata/www/driveschool/updatestep.log
#back up www every Saturday 0:00
0 0 * * 6 /backupdata/backup.sh
#back up mysql every day 0:00
0 0 * * * /backupdata/backupmysql.sh

backup.sh

#!/bin/bash
#back up strategy
backDir=/backupdata
PATH=/bin:/usr/bin:/sbin:/usr/sbin; export PATH
export LANG=C
www=/alidata/www
today=$(date +%Y-%m-%d)
[ ! -d "$backDir" ] && mkdir -p $backDir
#zip在crontab下不能正常工作!!!!
#zip $backDir/wwwbackup_$today.zip -r  $www/* 
tar -zvcf $backDir/wwwbackup_$today.tar.gz $www/*

backupmysql.sh

#!/bin/bash
user=root
pwd=3a2c898cf1
sqlDir=/backupdata/mysql
today=$(date +%Y-%m-%d)
[ ! -d "$sqlDir" ] && mkdir -p $sqlDir
mysqldump -u$user -p$pwd -B driveschool > $sqlDir/driveschool_$today.sql