xtrabackup备份脚本for mysql5.6

#!/bin/sh 
# 

MYSQL_USER=root
MYSQL_PASSWORD=mysqld
DATA_PATH=/backup/mysql_full
DATE=$(date +%Y%m%d)  
DATA_FILE=$DATA_PATH/xtra_fullbak_$DATE.tar.gz
LOG_FILE=$DATA_PATH/xtra_fullbak_$DATE.log
ORI_CONF_FILE=/u01/my3306/my.cnf
NEW_CONF_FILE=$DATA_PATH/my.cnf_$DATE

MYSQL_PATH=/usr/bin
MYSQL_DUMP="$MYSQL_PATH/innobackupex --defaults-file=$ORI_CONF_FILE --user=${MYSQL_USER} --password=${MYSQL_PASSWORD} -S /u01/my3306/run/mysql.sock --stream=tar /tmp"
echo -e "==== Jobs started at $(date +"%y-%m-%d %H:%M:%S") ===\n" >> $LOG_FILE
echo -e "*** first copy $ORI_CONF_FILE $NEW_CONF_FILE" >> $LOG_FILE
cp $ORI_CONF_FILE $NEW_CONF_FILE
echo -e "*** Excuted commend：${MYSQL_DUMP} |gzip > $DATA_FILE" >> $LOG_FILE
${MYSQL_DUMP} |gzip > $DATA_FILE
echo -e "*** Excuted finished：${MYSQL_DUMP} |gzip > $DATA_FILE" >> $LOG_FILE
echo -e "*** Bachkup file size："`du -sh $DATA_FILE`" ===\n" >> $LOG_FILE


echo -e "----Find expired backup and delete those file ----" >> $LOG_FILE
for tfile in $(/usr/bin/find $DATA_PATH/ -mtime +7)
do 
      if [-d $tfile ] ; then
              rmdir $tfile
          elif [-f $tfile] ; then
              rm $tfile
          fi
      echo "----Delete the file $tfile ----" >> $LOG_FILE
done 

echo -e "==== Jobs ended at $(date +"%y-%m-%d %H:%M:%S") ===\n" >> $LOG_FILE