dbcoy

#!/bin/bash


if [ 4 -ne $# ];
then
echo "arg error!"
echo "example(databaseIp userName userPasswd)"
fi


databaseIp=$1
userName=$2
userPasswd=$3
newDatabase=$4


#echo ${databaseIp} ${userName} ${userPasswd}


#arg(oldDbName newDbName tableName tableSubCount)
function copyTable()
{
oldDbName=$1
oldTableName=$3
tableSubCount=$4
newDbName=$2
newTableName=$3


for((i = 0; ${tableSubCount} > i; ++i));
do
sql="CREATE TABLE ${newDbName}.${newTableName}${i} LIKE ${oldDbName}.${oldTableName}${i}"
mysql -h${databaseIp} -u${userName} -p${userPasswd} -e"${sql}"

sql="INSERT INTO ${newDbName}.${newTableName}${i} select * from ${oldDbName}.${oldTableName}${i}"
mysql -h${databaseIp} -u${userName} -p${userPasswd} -e"${sql}"
done

}


copyTable nfyg ${newDatabase} table_ 2