目录结构:
test.sh
sql(aa.sql bb.sql cc.sql)
脚本如下:
test.sh
#!/bin/sh
sql_path=/opt/sql
log_file=$sql_path/sql_log.log
uname=root
pswd=123456
cd $sql_path
for sql_file in `ls *.sql`
do
dbname=`echo ${sql_file%.*}`
mysql -u$uname -p$pswd $d_name < $sql_file
done