#!/bin/bash
filename=../config/database.config
readFun(){
str=$1
checkKey=$2
varName=$3
if [[ $str =~ $checkKey ]];then
str1=${str#*\"}
result=${str1%\"*}
if [[ $result == $str ]];then
echo "格式不对!!!!:"$str
exit 2
fi
eval $varName=$result
fi
}
while read line
do
# 函数 参数字符串 过滤参数 变量名
readFun "$line" mysql_host mysqlHost
readFun "$line" mysql_user mysqlUser
readFun "$line" mysql_password mysqlPass
readFun "$line" mysql_database mysqlDatabase
done < $filename
echo "host:"$mysqlHost "user:"$mysqlUser "pass:"$mysqlPass "database:"$mysqlDatabase
echo "准备初始化数据库"
echo "输入内容:"$mysqlPass
mysql -h$mysqlHost -u$mysqlUser -p $mysqlDatabase < database.sql
state=$?
if [[ $state == 0 ]];then
echo "初始化数据库成功!!"
exit 0
fi
echo "初始化数据库失败~~"
database.config内容格式
{mysql_host,"xxx"},
{mysql_user,"xxx"},
{mysql_password,"xxx"},
{mysql_database,"xxx"},