Skip to content

Instantly share code, notes, and snippets.

@godcheese

godcheese/dbseed.cmd

Created August 19, 2017 07:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save godcheese/2be10fd8ceecda2ea8d9f89e73d2e942 to your computer and use it in GitHub Desktop.
Save godcheese/2be10fd8ceecda2ea8d9f89e73d2e942 to your computer and use it in GitHub Desktop.
Download ZIP
MYSQL数据库填充脚本
Raw
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.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment