#!/bin/bash

HOSTNAME="localhost"
PORT="3307"
USERNAME="root"
PASSWORD="mysql_Adkijc"

DB1="mir_account"
DB2="mir_actor_cross1"
DB3="mir_web"
DB4="mir_actor_s1"
DB5="mir_amdb"
DB6="mir_command"
DB7="mir_log_s1"
DB8="mir_name"

#创建数据库
#sql="GRANT ALL PRIVILEGES ON *.* TO '${USERNAME}'@'%' IDENTIFIED BY '${PASSWORD}'WITH GRANT OPTION;"
#sql0="FLUSH   PRIVILEGES;"
sql1="create database ${DB1} DEFAULT CHARACTER SET utf8;"
sql2="create database ${DB2} DEFAULT CHARACTER SET utf8;"
sql3="create database ${DB3} DEFAULT CHARACTER SET utf8;"
sql4="create database ${DB4} DEFAULT CHARACTER SET utf8;"
sql5="create database ${DB5} DEFAULT CHARACTER SET utf8;"
sql6="create database ${DB6} DEFAULT CHARACTER SET utf8;"
sql7="create database ${DB7} DEFAULT CHARACTER SET utf8;"
sql8="create database ${DB8} DEFAULT CHARACTER SET utf8;"

#mysql -u${USERNAME} -p${PASSWORD} -e "${sql}"
#mysql -u${USERNAME} -p${PASSWORD} -e "${sql0}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${sql1}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${sql2}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${sql3}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${sql4}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${sql5}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${sql6}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${sql7}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${sql8}"

#还原数据库
mysql -u${USERNAME} -p${PASSWORD} ${DB1} < ./sql/${DB1}.sql
mysql -u${USERNAME} -p${PASSWORD} ${DB2} < ./sql/${DB2}.sql
sleep 3
mysql -u${USERNAME} -p${PASSWORD} ${DB3} < ./sql/${DB3}.sql
mysql -u${USERNAME} -p${PASSWORD} ${DB4} < ./sql/${DB4}.sql
mysql -u${USERNAME} -p${PASSWORD} ${DB5} < ./sql/${DB5}.sql
mysql -u${USERNAME} -p${PASSWORD} ${DB6} < ./sql/${DB6}.sql
mysql -u${USERNAME} -p${PASSWORD} ${DB7} < ./sql/${DB7}.sql
mysql -u${USERNAME} -p${PASSWORD} ${DB8} < ./sql/${DB8}.sql






























































# 手 游 源  码 网 ： w w w . s y y  m w . c o m