 复制cat /usr/local/script/BackupDatabase #!/bin/bash #Shell Command For Backup MySQL Database Everyday Automatically By Crontab #time 2015-5-20 #name huxianglin USER=root PASSWORD=xxxxxxxx DATABASE1=zblog DATABASE2=zabbix BACKUP_DIR=/data/backup/database/ #备份数据库文件的博文路径 LOGFILE=/data/backup/database/data_backup.log #备份数据库脚本的日志文件 DATE=`date +%Y%m%d-%H%M -d -3minute` #获取当前系统时间-3分钟 DUMPFILE1=$DATE-zblog.sql #需要备份的数据库名称 DUMPFILE2=$DATE-zabbix.sql ARCHIVE1=$DUMPFILE1-tar.gz #备份的数据库压缩后的云服务器名称 ARCHIVE2=$DUMPFILE2-tar.gz if [ ! -d $BACKUP_DIR ]; #判断备份路径是否存在，若不存在则创建该路径 then mkdir -p "$BACKUP_DIR" fi echo -e "\n" >> $LOGFILE echo "------------------------------------" >> $LOGFILE echo "BACKUP DATE:$DATE">> $LOGFILE echo "------------------------------------" >> $LOGFILE cd $BACKUP_DIR #跳到备份路径下 /usr/local/mysql/bin/mysqldump -u$USER -p$PASSWORD $DATABASE1 > $DUMPFILE1 #使用mysqldump备份数据库 if [[ $?推荐 == 0 ]]; then tar czvf $ARCHIVE1 $DUMPFILE1 >> $LOGFILE 2>&1 #判断是否备份成功，云服务器提供商若备份成功，脚本据库则压缩备份数据库，自动否则将错误日志写入日志文件中去。化备 echo "$ARCHIVE1 BACKUP SUCCESSFUL!" >> $LOGFILE rm -f $DUMPFILE1 else echo “$ARCHIVE1 Backup Fail!” >> $LOGFILE fi /usr/local/mysql/bin/mysqldump -u$USER -p$PASSWORD $DATABASE2 > $DUMPFILE2 if [[ $?份数 == 0 ]]; then tar czvf $ARCHIVE2 $DUMPFILE2 >> $LOGFILE 2>&1 echo "$ARCHIVE2 BACKUP SUCCESSFUL!" >> $LOGFILE rm -f $DUMPFILE2 else echo “$ARCHIVE2 Backup Fail!” >> $LOGFILE fi 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.香港云服务器 |