整理编写比较灵活的shell脚本
cat mysqlautobackup.sh
#!/bin/sh
# mysql data backup script
#
# use mysqldump --help,get more detail.
#
BakDir=/home/mysql/mysqlbackup/databak
LOGDATE=`date +%Y%m`
LogFile=/home/mysql/mysqlbackup/backuplog/$LOGDATE.log
DATE=`date +%Y%m%d%H%M%S`
echo " " >> $LogFile
echo " " >> $LogFile
echo "---------begin-----------------" >> $LogFile
echo $(date +"%Y-%m-%d %H:%M:%S") >> $LogFile
echo "---------begin-----------------" >> $LogFile
cd $BakDir
# yidong backup
yidongDumpFile=yidong_$DATE.sql
yidongGZDumpFile=yidong_$DATE.sql.tar.gz
/usr/bin/mysqldump -uroot -proot --default-character-set=utf8 yidong > $yidongDumpFile
echo "yidongDump Done" >> $LogFile
tar czvf $yidongGZDumpFile $yidongDumpFile >> $LogFile 2>&1
echo "[$yidongGZDumpFile]Backup Success!" >> $LogFile
rm -f $yidongDumpFile
# jeewx backup
jeewxDumpFile=jeewx_$DATE.sql
jeewxGZDumpFile=jeewx_$DATE.sql.tar.gz
/usr/bin/mysqldump -uroot -proot --default-character-set=utf8 jeewx > $jeewxDumpFile
echo "jeewxDumpFile Done" >> $LogFile
tar czvf $jeewxGZDumpFile $jeewxDumpFile >> $LogFile 2>&1
echo "[$jeewxGZDumpFile]Backup Success!" >> $LogFile
rm -f $jeewxDumpFile
echo "Backup Done!" >> $LogFile
echo "---------end-------------------" >> $LogFile
echo $(date +"%Y-%m-%d %H:%M:%S") >> $LogFile
echo "---------end-------------------" >> $LogFile
# delete backup
#find $BakDir/* -ctime 30 -exec rm {} \;
#echo "delete file over 30 days" >> $LogFile
设置CentOS定时任务执行该脚本;
1、编辑定时任务列表
2、插入下面这一行,因为通常来说5点钟网站的访问量最低。
00 03 * * * /bin/sh /home/mysql/mysqlbackup/mysqlautobackup.sh
#每天早上 3:00am 执行
3、查看任务是否创建成功
crond服务
安装crontab:
yum install crontabs
服务操作说明:
/sbin/service crond start //启动服务
/sbin/service crond stop //关闭服务
/sbin/service crond restart //重启服务
/sbin/service crond reload //重新载入配置
/sbin/service crond status //启动服务
恢复
####数据解压(看压缩包是哪种在进行)
[root]# gzip -d yidong_201611020300.sql.gz
[root]# tar -xzvf yidong_201611020300.sql.tar.gz
####导入数据库
mysql -uroot -p --default-character-set=utf8 yidong
set global max_allowed_packet=1000000000;
source yidong_201611020300.sql