一、全量备份脚本

    1.全量备份脚本

#!/bin/bash#Description:xtrabackup complete#Author:created by michael#2017-08-07 v0.1#USER=rootPASSWD=123456BACKUP_DIR=/backup/mysql/completeDATE=$(date +"%F_%T")[[ -d $BACKUP_DIR ]] || mkdir $DATE_DIRinnobackupex --user=$USER --password=$PASSWD $BACKUP_DIR &> /tmp/mysql/"$DATE".txtegrep ".* Backup created in directory.*" /tmp/mysql/"$DATE".txt >> $BACKUP_DIR/complete.inform -rf /tmp/mysql/"$DATE".txt

    2.启动crond以及开机自启动crond

systemctl start crondsystemctl enable crond

    3.授予执行权限

chmod 755 /root/script/backup_complete.sh

    4.每周六的凌晨4点整定时执行全量备份

[root@michaelos complete]# crontab -ecrontab: installing new crontab[root@michaelos complete]# crontab -l0 4 * * 6 /root/script/backup_complete.sh

二、增量备份脚本

    1.增量备份脚本

[root@michaelos script]# cat backup_increment.sh #!/bin/bash #Description: mysql backup incremention#Author:michael#2017-08-07 v0.1#USER=rootPASSWORD=123456BACKUP_DIR=/backup/mysql/incrementDATE=$(date +"%F_$T")BASE_DIR=$(tail -1 /backup/mysql/complete/complete.info | cut -d\' -f2)[[ -d $BACKUP_DIR ]] || mkdir $BACKUP_DIRinnobackupex --user=$USER --password=$PASSWORD --incremental $BACKUP_DIR --incremental-basedir=$BASE_DIR &> /tmp/mysql/"$DATE".txtegrep ".*Backup created in directory.*" /tmp/mysql/"$DATE".txt >> $BACKUP_DIR/backup.inform -rf /tmp/mysql/"$DATE".txt

    2.授予执行权限     

chmod 755 backup_increment.sh

    3.每周二、四、日的凌晨2点执行增量备份

[root@michaelos script]# crontab -l0 4 * * 6 /root/script/backup_complete.sh0 2 * * 2,4,7 /root/script/backup_increment.sh