mysql备份脚本--mysqlpump

#!/bin/bash
set -eu
exclude_acc_tables=XXXXX
exclude_tms_tables=XXXXX
exclude_tms_string=''
exclude_acc_string=''
for tms_tb in "${exclude_tms_tables[@]}"
do
exclude_tms_string+=" --exclude-tables=${tms_tb}"
done
for acc_tb in "${exclude_acc_tables[@]}"
do 
exclude_acc_string+=" --exclude-tables=${acc_tb}"
done
backfiledir=/logs/mysqlbackupfile
backuplist=/data/scripts/mysqlscripts/dumplist
backuptype=mysqlpump
center_DB_IP=XXXXXX
center_DB_Port=XXXXXX
basedir=/usr/local/mysql/bin
username=root
passwd=XXXXXXX
for dbname in `cat $backuplist`
do
remoteIP=`echo $dbname|cut -d '_' -f 1`
BACKUPStarttime=`date +%Y%m%d%H%M%S`
if [ "$remoteIP" == "XXXXXX" ]; then
$basedir/mysqlpump --user=$username --password=$passwd --add-drop-database --host=$remoteIP -A --single-transaction -