这是一个使用bash shell脚本创建多个MySQL数据库并从.sql文件中导入数据的例子。脚本首先定义了数据库连接参数，然后创建数据库，最后分别使用`source`命令从指定路径的SQL文件导入数据。
#!/bin/bash
HOSTNAME=“localhost” #数据库信息
PORT=“3306”
USERNAME=“root”
PASSWORD=“123456”
DBNAMEMAIN=“ma”
DBNAMENETMAC=“netm”
DBNAMEOPERATDATA=“operat”
DBNAMEWIFISITE=“wifi”
usemain=“use $DBNAMEMAIN”
usenetmac=“use $DBNAMENETMAC”
useopera=“use $DBNAMEOPERATDATA”
usewifi=“use $DBNAMEWIFISITE”
create_db_sql=“create database $DBNAMEMAIN”
createdbnet=“create database $DBNAMENETMAC”
createdboper=“create database $DBNAMEOPERATDATA”
createdbwifi=“create database %DBNAMEWIFISITE”
mysql -h ${HOSTNAME} -u
U
S
E
R
N
A
M
E
−
p
{USERNAME} -p
USERNAME−p{PASSWORD} -e"${create_db_sql}"
mysql -h ${HOSTNAME} -u
U
S
E
R
N
A
M
E
−
p
{USERNAME} -p
USERNAME−p{PASSWORD} -e"${createdbnet}"
mysql -h ${HOSTNAME} -u
U
S
E
R
N
A
M
E
−
p
{USERNAME} -p
USERNAME−p{PASSWORD} -e"${createdboper}"
mysql -h ${HOSTNAME} -u
U
S
E
R
N
A
M
E
−
p
{USERNAME} -p
USERNAME−p{PASSWORD} -e"${createdbwifi}"
mysql -h ${HOSTNAME} -u U S E R N A M E − p {USERNAME} -p USERNAME−p{PASSWORD} -e"${usemain}"
source /GACenter/main/main.sql
mysql -h ${HOSTNAME} -u U S E R N A M E − p {USERNAME} -p USERNAME−p{PASSWORD} -e"${usenetmac}"
source /GACenter/netmac/netmac.sql
mysql -h ${HOSTNAME} -u U S E R N A M E − p {USERNAME} -p USERNAME−p{PASSWORD} -e"${useopera}"
source /GACenter/operatdata/operatdata.sql
mysql -h ${HOSTNAME} -u
U
S
E
R
N
A
M
E
−
p
{USERNAME} -p
USERNAME−p{PASSWORD} -e"${usewifi}"
source /GACenter/wifisite/wifisite.sql
格式是这样的 命名我修改了
扫一扫
1806
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
