导入数据库脚本-KeepStudy

导入数据库脚本

```shell
#!bin/bash
#导入数据库脚本

HOSTNAME="127.0.0.1"
PORT="3306"
USERNAME="root"
PASSWORD="root"
PATH="/data/mysql_backup/"

for file in `/usr/bin/ls ${PATH}`
do
    #@1 获取 . 的位置
    index=`/usr/bin/expr index "${file}" .`
    index=`/usr/bin/expr ${index} - 1`

#@2 截取文件名 得到数据库名
    DBNAME=${file:0:${index}}

echo ${DBNAME}

#@3 创建库
    echo "create database"
    SQL="create database IF NOT EXISTS ${DBNAME} DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"
    /usr/bin/mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${SQL}"

#@4 连接数据库
    connDB="/usr/bin/mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} ${DBNAME}"

#@5 创建表
   echo "create tables"
   SQL="source /home/wwwroot/game_backstage/shell/game_log.sql"
   ${connDB} -e "${SQL}"

#@6 解压文件
   echo "unzip file"
   /usr/bin/unzip ${PATH}/${file} -d ${PATH}

#@7 导入库
   echo "source sql"
   SQL="source ${PATH}/${DBNAME}.sql"
   ${connDB} -e "${SQL}"

#@8 删除文件
   echo "rm file"
   /usr/bin/rm -rf ${PATH}/${DBNAME}.sql

#@9 把已处理完的zip文件移动到 /data/mysql_backup_ok/ 避免再次处理
   /usr/bin/mv ${PATH}/${file} /data/mysql_backup_ok/

#@10 添加存储过程、触发器、id和索引
   echo "add pro\tri\id\index"
   SQL="source /home/wwwroot/game_backstage/shell/add.sql"
   ${connDB} -e "${SQL}"

echo ""
done
echo "success"
exit 0

```

顶部

Shell应用

目录

相关推荐