shell脚本建多库、多表、多实例(mysql)
我的博客已迁移到xdoujiang.com请去那边和我交流cat createdbtable.sh
#!/bin/bash
#--------------------------------------------------
#Created:2015-05-26
#Author:jimmygong
#Mail:jimmygong@taomee.com
#Function:
#Version:1.0
#--------------------------------------------------
mysqluser="mysql"
mysqlpass="redhat"
mysqlport="3306"
alldatabases=(aaa bbb ccc ddd eee fff ggg hhh iii jjj)
alltables=(t1 t2 t3 t4 t5 t6 t7 t8 t9 t10)
function mysqlconn ()
{
mysqlip=$1
comm=$2
mysql -u${mysqluser} -p${mysqlpass} -h${mysqlip} -P${mysqlport} -e "$comm"|sed 1d
}
function createdbtable ()
{
for ((j=0;j
页:
[1]