#!/bin/bash
user=root
passwd=123456
host=127.0.0.1
db_list=(test1 test2 test3)
file_head=backup
file_path=/data_backup/mysql_backup
index=0
len=${#db_list[*]}
date_now=`date +%F`
for i in ${db_list[@]}
do
echo '------------------------------------------------------------'
let index++
echo "bakup $i $index/$len"
echo "shart `date +%F_%H:%M:%S`"
#echo "user:$user passwd:$passwd"
/usr/local/bin/mysqldump -h $host -u $user -p $passwd --set-gtid-purged=OFF --master-data=2 --single-transaction --routines -B $i | /usr/bin/gzip -c > $file_path/"$file_head"_bak"$date_now"_"$i".sql.gz
echo -e "end `date +%F_%H:%M:%S`\n"
sleep 2
done
echo '----------------------------End------------------------------'