#!/bin/bash
PATH=$PATH:$HOME/bin
export PATH=/veris/usr/bin:/veris/usr/sbin:$PATH
export LD_LIBRARY_PATH=/veris/usr/lib64:$LD_LIBBRARY_PATH
THREAD_NUM=3
tmp_fifofile="/tmp/$$.fifo"
mkfifo "$tmp_fifofile"
exec 6<>"$tmp_fifofile"
rm $tmp_fifofile
for ((i=0;i<$THREAD_NUM;i++))
do
echo
done >&6
db_port=5310
db_list=`
mysql -h127.0.0.1 -uroot -pxxxxx -A -P
${db_port} -ss -e "select SCHEMA_NAME from information_schema.SCHEMATA where SCHEMA_NAME not in('information_schema','mysql','test','performance_schema')
"`
for db_name in ${db_list}
do
read -u6
{
echo ${db_name}
mysqldump -h127.0.0.1 -uroot -pxxxxx -P${db_port} -B -R --default-character-set=utf8 --opt --max-allowed-packet=64M --net_buffer_length=163840 --
single-transaction -f ${db_name} > /tmp/${db_port}.${db_name}.sql
echo >&6
} &
pid=$!
echo $pid
done
wait
exec 6>&-
exit 0