分库分表合并导出脚本

#!/bin/sh
dumpdate=`/bin/date +%Y%m%d`
tmpfile=user_order_$dumpdate.sql
/home/soft/mysql/bin/mysqldump -h1.1.1.1 -ucharge -pxxxxxx-P8306 chargeservice user_order --skip-lock-tables --set-gtid-purged=OFF > $tmpfile
/home/soft/mysql/bin/mysqldump -h1.1.1.1 -ucharge -pxxxxxxf -P8307 chargeservice user_order --skip-lock-tables --set-gtid-purged=OFF --no-create-info >> $tmpfile
gzip $tmpfile