首页 > 服务器运维 > 定时备份mysql和网站目录文件

定时备份mysql和网站目录文件

2013年11月6日 Terence 106 次阅读 发表评论 阅读评论

      今天继续维护网站,目的主要是为了能自动备份数据库和网站目录文件,然后使用crond服务设定计划任务成每天定时执行。写完shell脚本实验了一下感觉还不错,特把脚本文件共享出来以供参考。

      首先是自动备份数据库的脚本:

#!/bin/bash
#!/bin/bash
#This is a ShellScript For Auto DB Backup
 
#Setting
#设置数据库名,数据库登录名,密码,备份路径,日志路径,数据文件位置,以及备份方式
#默认情况下备份方式是tar,还可以是mysqldump
#默认情况下,用root(空)登录mysql数据库,备份至/root/dbxxxxx.tar.gz
#mysqldump情况下,会重启httpd服务
DBName=db
DBUser=root
DBPasswd=
BackupPath=/root/
LogFile=/root/db.log
DBPath=/var/lib/mysql/
BackupMethod=mysqldump
#BackupMethod=tar
#Setting End
 
NewFile="$BackupPath"db$(date +%y%m%d).tar.gz
DumpFile=db$(date +%y%m%d).sql
OldFile="$BackupPath"db$(date +%y%m%d --date='30 days ago').tar.gz
 
echo "-------------------------------------------" >> $LogFile
echo $(date +"%y-%m-%d %H:%M:%S") >> $LogFile
echo "--------------------------" >> $LogFile
#Delete Old File
if [ -f $OldFile ]
then
 rm -f $OldFile >> $LogFile 2>&1
 echo "[$OldFile]Delete Old File Success!" >> $LogFile
else
 echo "[$OldFile]No Old Backup File!" >> $LogFile
fi
 
if [ -f $NewFile ]
then
 echo "[$NewFile]The Backup File is exists,Can't Backup!" >> $LogFile
else
 case $BackupMethod in
 mysqldump)
     cd $BackupPath
     service httpd stop >> $LogFile
     if [ -z $DBPasswd ]
     then
        mysqldump -u $DBUser --opt $DBName > $DumpFile
     else
        mysqldump -u $DBUser -p$DBPasswd --opt $DBName > $DumpFile
     fi
     tar czvf $NewFile $DumpFile >> $LogFile 2>&1
     echo "[$NewFile]Backup Success!" >> $LogFile
     rm -rf $DumpFile
     service httpd start >> $LogFile
     ;;
 *)
     /etc/init.d/mysqld stop >/dev/null 2>&1
     tar czvf $NewFile $DBPath$DBName >> $LogFile 2>&1
     /etc/init.d/mysqld start >/dev/null 2>&1
     echo "[$NewFile]Backup Success!" >> $LogFile
     ;;
 esac
fi
 
echo "-------------------------------------------" >> $LogFile

      随后是自动备份网站目录的脚本:

#!/bin/bash
#!/bin/bash
#This is a ShellScript For Web Files Backup
 
#Setting
#设置备份路径,日志路径,web文件位置
#默认情况下,备份至/root/webxxxxx.tar.gz
BackupPath=/root/
LogFile=/root/web.log
WebPath=/var/www/html/
#Setting End
 
NewFile="$BackupPath"web$(date +%y%m%d).tar.gz
OldFile="$BackupPath"web$(date +%y%m%d --date='30 days ago').tar.gz
 
echo "-------------------------------------------" >> $LogFile
echo $(date +"%y-%m-%d %H:%M:%S") >> $LogFile
echo "--------------------------" >> $LogFile
#Delete Old File
if [ -f $OldFile ]
then
 rm -f $OldFile >> $LogFile 2>&1
 echo "[$OldFile]Delete Old File Success!" >> $LogFile
else
 echo "[$OldFile]No Old Backup File!" >> $LogFile
fi
 
if [ -f $NewFile ]
then
 echo "[$NewFile]The Backup File is exists,Can't Backup!" >> $LogFile
else
 cd $WebPath
 tar czvf $NewFile . >> $LogFile 2>&1
 echo "[$NewFile]Backup Success!" >> $LogFile
fi
 
echo "-------------------------------------------" >> $LogFile

      最后就是cron脚本,这个比较简单,修改/etc/crontab文件就可以了:

SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/
 
# For details see man 4 crontabs
 
# Example of job definition:
# .---------------- minute (0 - 59)
# |  .------------- hour (0 - 23)
# |  |  .---------- day of month (1 - 31)
# |  |  |  .------- month (1 - 12) OR jan,feb,mar,apr ...
# |  |  |  |  .---- day of week (0 - 6) (Sunday=0 or 7) OR sun,mon,tue,wed,thu,fri,sat
# |  |  |  |  |
# *  *  *  *  * user-name command to be executed
0 4 * * * root /root/dbbackup.sh
5 4 * * * root /root/webbackup.sh

      需要注意的是crontab修改完后需要重启crond服务,dbback.sh和webbackup.sh文件需要添加可执行权限。





分类: 服务器运维 标签: , ,
  1. 本文目前尚无任何评论.