#!/bin/bash
###update on 20150604 ,add delete AUTO_INCREMENT
###update on 20151008,add set-gtid-purged=OFF to delete @@global.gtid_purged statements in the bak file
PATH=/us...
#!/bin/bash
###update on 20150604 ,add delete AUTO_INCREMENT
###update on 20151008,add set-gtid-purged=OFF to delete @@global.gtid_purged statements in the bak file
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/webdata/opt/local/mysql/bin
export PATH
HOST='localhost'
USER=root
PASS='xxxx'
SOCK=/webdata/opt/local/mysql/misc/mysql.sock
THREAD_NUM=4
BAK_DIR=/webdata/hotbak
DB_BAK_DATE=`date +%Y%m%d`
DB_BAK_DATE_T=`date +%Y%m%d --date='-2 days'`
ops='--no-timestamp'
/bin/rm -rf $BAK_DIR/$DB_BAK_DATE_T
innobackupex --user=$USER --password=$PASS --parallel=$THREAD_NUM $ops --socket=$SOCK $BAK_DIR/$DB_BAK_DATE
innobackupex --apply-log $BAK_DIR/$DB_BAK_DATE
