mysql批量创建数据库并导入数据的shell脚本

#!/bin/bash
#批量创建数据库并导入数据的脚本

#定义变量
HOSTNAME="localhost" #数据库信息
PORT="3306"
USERNAME="root"
PASSWORD="123456"
CHARSET="utf8mb4"
DBNAMES=("db1" "db2" "db3") #数据库名数组
SQLFILES=("db1.sql" "db2.sql" "db3.sql") #对应的sql文件名数组

#遍历数组，逐个创建数据库并导入数据
for ((i=0;i<${#DBNAMES[@]};i++))
do
#创建数据库
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} --default-character-set=${CHARSET} -e "CREATE DATABASE IF NOT EXISTS ${DBNAMES[i]}"

#导入数据
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} --default-character-set=${CHARSET} ${DBNAMES[i]} < ${SQLFILES[i]}
done

echo "All databases have been created and data have been imported successfully!"