MYSQL之二(MYSQL备份)

------------------------------------------ 备份Jogos321 xtrabackup_all_db_tar.sh -----------------------------------------------------------


#!/bin/bash
#this shell is user for backup mysql data everyday
#author:Sakura.Gaara
#dir-config
BACKUP_DIR=/data/backup/databases/full_innobackup/
XTRABACKUP_BIN=/data/backup/tools/xtrabackup/bin/
MYCNF_DIR=/etc/
LOGS_BACKUP_FILE=${BACKUP_DIR}`date +%Y%m%d`.log
TAR_BACKUP_FILE=${BACKUP_DIR}`date +%Y%m%d`.tar.gz


#mysql-config
MYSQL_USER="root"
MYSQL_PASS="password"



mkdir -p ${BACKUP_DIR}
echo "开始备份..."`date`>>${LOGS_BACKUP_FILE}
echo "开始备份..."`date`
${XTRABACKUP_BIN}innobackupex-1.5.1 --defaults-file=${MYCNF_DIR}my.cnf --no-lock --user=${MYSQL_USER} --password=${MYSQL_PASS} --slave-info ${BACKUP_DIR} 2>>${LOGS_BACKUP_FILE}

sleep 60


cd ${BACKUP_DIR}
if [ -d ${BACKUP_DIR}`date -d "-7 day" +%Y-%m-%d`* ]
then
rm -rf ${BACKUP_DIR}`date -d "-7 day" +%Y-%m-%d`*
fi

if [ -f ${BACKUP_DIR}`date -d "-7 day" +%Y%m%d`* ]
then
rm -rf ${BACKUP_DIR}`date -d "-7 day" +%Y%m%d`*
fi

echo "备份完毕..."`date`

if [ `grep -i error ${LOGS_BACKUP_FILE}|wc -l` -gt 0 ]; then
    cat ${LOGS_BACKUP_FILE} |mail -s "$HOSTNAME Slave MYSQL BACKUP is Error." [e-mail]
    cat ${LOGS_BACKUP_FILE} |mail -s "$HOSTNAME Slave MYSQL BACKUP is Error." [e-mail]
fi


## 10 02 * * * /root/shell/xtrabackup_all_db_tar.sh