mysql多方式自动备份脚本(mysqldump,mydumper,xtrabackup)
mysql多方式自动备份脚本(mysqldump,mydumper,xtrabackup)
#!/bin/
export PATH=/usr/local/mysql/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/ export LANG=
ROOT=/data/bw_mon/ LOG=$ROOT/ RUN=$ROOT/ LOCAL_DATA=$ROOT/ CONF=$ROOT/ _ErrLog=$Log/
# tag
RUN_TAG=$RUN/
# log
LOG0=$LOG/bw_mysqlbk.log ; LOG1=$LOG0. ; LOG2=$LOG0. ; LOG3=$LOG0.
nowtime=` +%Y%m%d_%H% delnowtime=` -d +%Y%m%d_%H% xtrabackcmdlog=$LOG/ xtrabackcmddellog=$LOG/ [[ -f $xtrabackcmddellog ]] || - # define temp
MAIL_TMP=$RUN/
MAIL_TITLE=
Week=$( +% Bindir=$LOCAL_DATA/bin-
# read configuration [[ -f $CONF/bw_mysqlbk.conf && -f $CONF/
. $CONF/ . $CONF/
exit
datef() { print_to_log() { >> print_to_mail() { >> print_file_to_mail() { $ >> append_mail_title() { MAIL_TITLE=
[[ $telphonesms == ]] ;
/usr/local/bin/sendsmspost.pl app_backup $IP_ADDR==$Now===$content=backup--faild!
/usr/local/bin/sendsmspost.pl app_backup $IP_ADDR==$Now===$content=backup--faild!
/usr/local/bin/sendsmspost.pl app_backup $IP_ADDR==$Now===$content=backup--faild!
/usr/local/bin/sendsmspost.pl app_backup $IP_ADDR==$Now===$content=backup--faild!
/usr/local/bin/sendsmspost.pl app_backup $IP_ADDR==$Now===$content=backup--faild!
/usr/local/bin/sendsmspost.pl app_backup $IP_ADDR==$Now===$content=backup--faild!
binif=$(mysql -u ${Usr} -p${Pwd} -e --batch | | Datedir=$(mysql -u ${Usr} -p${Pwd} -e --batch | | binlogfile=`mysql -u ${Usr} -p${Pwd} -e --batch | -v | [[ $binif == ]];
i
[[ -d $Bindir/$BACKUP_SERIAL ]] || -p $Bindir/
Delbindir=` $Bindir -type d -name $Bindelday* [[ -d $Delbindir ]] ;
- print_to_log
desdir=$Bindir/
[ $? -ne