MYSQL数据库填充脚本

dbseed.cmd

chcp 65001

@REM Author:godcheese@qq.com
@REM Description:MYSQL数据库填充脚本
@REM Platform:Windows

@echo off

set "MYSQL_HOME=D:\dev\mysql\mysql5.7.14"
set "HOST=localhost"
set "PORT=3306"
set "USER=testuser"
set "PASSWORD=testpwd"
set "DATABASE=testdb"
set "DATA=D:\dev\testdb\data"
set "EXEC=%MYSQL_HOME%\bin\mysql.exe -h%HOST% -P%PORT% -u%USER% -p%PASSWORD% -D%DATABASE%<%DATA%"

%EXEC%\1_ict_logs_data.sql
%EXEC%\2_ict_areas_data.sql
echo finished.