scaoping 发表于 2018-8-25 09:42:29

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]
查看完整版本: shell脚本建多库、多表、多实例(mysql)