#!/bin/sh
USER_NAME=数据库用户名
PASS_WORD=数据库用户密码
MYSQL_EXEC=mysql目录
function update_db()
{
host=$1
db=$2
echo $host $db
file=$3
$MYSQL_EXEC -u$USER_NAME -p$PASS_WORD -h$host -A $db < $file
}
function update_all()
{
host=$1
file=$2
for i in `$MYSQL_EXEC -u$USER_NAME -p$PASS_WORD -h$host -e "show databases"|awk 'NR>1{print $0}'`; do
exists=`grep -w $i exclude.list`
if [ "$exists" != "" ]; then
continue
fi
update_db $host $i $file
done
}
function usage()
{
echo "Usage sh $0 file"
}
file=$1
if [ ! -f "$file" ]; then
usage
exit
fi
for i in `cat db.list`; do
update_all $i $1 &
done
USER_NAME=数据库用户名
PASS_WORD=数据库用户密码
MYSQL_EXEC=mysql目录
function update_db()
{
host=$1
db=$2
echo $host $db
file=$3
$MYSQL_EXEC -u$USER_NAME -p$PASS_WORD -h$host -A $db < $file
}
function update_all()
{
host=$1
file=$2
for i in `$MYSQL_EXEC -u$USER_NAME -p$PASS_WORD -h$host -e "show databases"|awk 'NR>1{print $0}'`; do
exists=`grep -w $i exclude.list`
if [ "$exists" != "" ]; then
continue
fi
update_db $host $i $file
done
}
function usage()
{
echo "Usage sh $0 file"
}
file=$1
if [ ! -f "$file" ]; then
usage
exit
fi
for i in `cat db.list`; do
update_all $i $1 &
done
转载于:https://blog.51cto.com/yangshi/1168641