mysql批量建库及数据导入

#!/bin/sh
#set -x
dir1=/data/bak3303_201306251459/
dir2=/usr/local/mysql/bin/
dir3=/data
ls -al $dir1|awk '{print $8}'|awk -F. '{print $1}' > $dir3/table.txt
cd $dir2
for i in `cat $dir3/table.txt`
do
./mysql -uroot -p123456 -e "create database $i;"
#echo $i
done
for j in `ls -al $dir1|awk '{print $8}'`
do
./mysql -uroot -p123456 $i < $j
#echo $j
done
#set +x      

貌似死循环，还有待纠正。。。

#!/bin/sh
#set -x
dir1=/data/bak3303_201306251459/
dir2=/usr/local/mysql/bin/
dir3=/data
ls -l $dir1|awk '{print $8}'|sed -n '2,$p'|awk -F . '{print $1}' > $dir3/table.txt
cd $dir2
for i in `cat $dir3/table.txt`
do
        j=$i.sql
        ./mysql -uroot -p123456 -e "create database $i default charset=utf8
;"
        ./mysql -uroot -p123456 $i < $dir1$j
done
#set +x