定时备份数据库和网站程序的脚本
本帖最后由 米拿现’ 于 2012-12-9 21:57 编辑
#!/bin/bash
#Funciont: Backup website and mysql database
#IMPORTANT!!!Please Setting the following Values!
######~Set Directory you want to backup~######
Backup_Dir1=fanshuwo.me
######~Set MySQL UserName and password~######
MYSQL_UserName=root
MYSQL_PassWord=yourrootpassword
######~Set MySQL Database you want to backup~######
Backup_Database_Name1=fanshuwo
######~Set FTP Information~######
FTP_HostName=192.168.0.150
FTP_UserName=fanshuwo.me
FTP_PassWord=yourftppassword
FTP_BackupDir=backup
#Values Setting END!
TodayWWWBackup=www-*-$(date +"%Y%m%d").tar.gz
TodayDBBackup=db-*-$(date +"%Y%m%d").sql
OldWWWBackup=www-*-$(date -d -3day +"%Y%m%d").tar.gz
OldDBBackup=db-*-$(date -d -3day +"%Y%m%d").sql
tar zcf /home/backup/www-$Backup_Dir1-$(date +"%Y%m%d").tar.gz -C /home/wwwroot/$Backup_Dir1 –exclude=soft
/usr/local/mysql/bin/mysqldump -u$MYSQL_UserName -p$MYSQL_PassWord $Backup_Database_Name1 > /home/backup/db-$Backup_Database_Name1-$(date +"%Y%m%d").sql
rm -f /home/backup/$OldWWWBackup
rm -f /home/backup/$OldDBBackup
cd /home/backup/
lftp $FTP_HostName -u $FTP_UserName,$FTP_PassWord << EOF
cd $FTP_BackupDir
mrm $OldWWWBackup
mrm $OldDBBackup
mput $TodayWWWBackup
mput $TodayDBBackup
bye
EOF
——————– 给755的权限(chmod 755 ),结合crond 定时备份。