mysql数据备份脚本-利用innobackup(xtra)

路径：

全量备份：
[root@localhost mysql]# cat mysql_backup.sh

#!/bin/bash

IP=192.168.10.150
USER=root
PWD=123456
PORT=3316
DATADIR=/qj/mysql/data/
BACKDIR=/qj/mysql/backup/

#判断文件夹是否存在
if [ -d $BACKDIR ];then
        rm -rf $BACKDIR*
        echo -e "\033[1;32m---------------------Delete $BACKDIR* dirctory-----------------------\033[0m"
else
	mkdir -p $BACKDIR
        echo -e "\033[1;32m---------------------Add a new dirctory $BACKDIR-----------------------\033[0m"
fi

#全量备份
innobackupex --host=$IP --user=$USER --password=$PWD --port=$PORT --no-timestamp --compress --datadir=$DATADIR $BACKDIR


DATE='date +%Y%m%d'
echo `${DATE}`_full.tar.gz
tar -zcf `${DATE}`_full.tar.gz backup
FILEPATH=`find /qj/mysql/ -name "*.tar.gz"` 
FILE=${FILEPATH##*/}

#上传阿里云对象存储
/usr/local/oss/ossutil64 cp -r $FILE oss://qjmis/test_kxq/

#删除本地备份文件
rm -rf `${DATE}`_full.tar.gz 

增量备份：
[root@localhost mysql]# cat mysql_backup_incre.sh

#!/bin/bash

IP=192.168.10.150
USER=root
PWD=123456
PORT=3316
DATADIR=/qj/mysql/data/
BACKDIR=/qj/mysql/backup/
INCREDIR=/qj/mysql/incre/


if [ -d $INCREDIR ];then
	rm -rf $INCREDIR*
	echo -e "\033[1;32m---------------------Delete $INCREDIR* dirctory-----------------------\033[0m"
else
	mkdir -p $INCREDIR
	echo -e "\033[1;32m---------------------Add a new dirctory $INCREDIR-----------------------\033[0m"
fi


#增量备份
innobackupex --host=$IP --user=$USER --password=$PWD --port=$PORT --compress --no-timestamp --datadir=$DATADIR --incremental $INCREDIR --incremental-basedir=$BACKDIR

DATE='date +%Y%m%d'
echo `${DATE}`_incre.tar.gz
tar -zcf `${DATE}`_incre.tar.gz backup
FILEPATH=`find /qj/mysql/ -name "*.tar.gz"` 
FILE=${FI`LEPATH##*/}`

#上传阿里云对象存储
/usr/local/oss/ossutil64 cp -r $FILE oss://qjmis/test_kxq/

#删除本地备份文件
rm -rf `${DATE}`_incre.tar.gz