#!/bin/bashMasterIp=*USER=rootPORT=3306PASSWD=000000DATE=`date +%Y-%m-%d`#DATE_NOW=`date +%Y-%m-%d.%H%M`DATE_NOW=`date +%Y-%m-%d`OLDDATE=`date +%Y-%m-%d -d "30 days ago"`#全表备份BACKUPDIR=/data/mysql_backup/fulltable#单表tb_trcevt备份datapath='/data/mysql_backup/tb_trcevt'logpath='/data/mysql_backup/log'backtable=tb_trcevtbacktable_db=bim#binlogBINLOG=/data/binlogserverDATA_DIR_binlog=/data/mysql/binlogPATH=/usr/local/mysql/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbinexport PATHfunction stop() {ps uax | grep mysqlbinlog | grep raw | awk '{print $2}' | xargs kill}if [ ! -d ${logpath} ];thenmkdir -p ${logpath}fiif [ ! -d ${BACKUPDIR} ];thenmkdir -p ${BACKUPDIR}fiif [ ! -d ${datapath} ];thenmkdir -p ${datapath}ficd ${BACKUPDIR}/echo ”备份时间为${DATE},开始----” >> ${logpath}/dbback.logmysqladmin -u${USER} -p${PASSWD} flush-logs#mysqldump -u${USER} -p${PASSWD} -h${MasterIp} --flush-logs -A -R -E --triggers --master-data=2 --delete-master-logs --single-transaction > full_${DATE_NOW}.sql#mysqldump -u${USER} -p${PASSWD} -h${MasterIp} --flush-logs -A -R -E --triggers --master-data=2 --single-transaction > full_${DATE_NOW}.sqlmysqlpump -u${USER} -p${PASSWD} -h${MasterIp} --single-transaction --default-character-set=utf8 --compress-output=LZ4 --default-parallelism=3 -A --routines --events --triggers > full_${DATE_NOW}.sqlif [[ $? == 0 ]];thencd $BACKUPDIR#为节约硬盘空间，将数据库压缩tar zcvf full_${DATE_NOW}.tar.gz full_${DATE_NOW}.sql > /dev/null 2>&1#删除原始文件，只留压缩后文件rm -f full_${DATE_NOW}.sqlecho "数据库备份数据成功!!" >> ${logpath}/dbback.logelseecho "数据库备份数据失败!!" >> ${logpath}/error.logficd ${BACKUPDIR}/echo ”备份时间为${DATE},开始----” >> ${logpath}/tableback.logmysqldump -t $backtable_db -h${VIP} --set-gtid-purged=OFF -u${USER} -p${PASSWD} --tables ${backtable} >${datapath}/${backtable}.sqlmysql -u${USER} -p${PASSWD} -h${VIP} -D $backtable_db -e 'TRUNCATE TABLE tb_trcevt'if [[ $? == 0 ]];thencd $datapath#为节约硬盘空间，将数据库压缩tar zcvf ${backtime}${backtable}.tar.gz ${backtable}.sql > /dev/null 2>&1#删除原始文件，只留压缩后文件rm -f ${datapath}/${backtable}.sqlecho "数据库备份${backtable}表数据成功!!" >> ${logpath}/tableback.logelseecho "数据库备份${backtable}表数据失败!!" >> ${logpath}/table_error.logfi
