MYSQL数据库迁移脚本

migrate.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 "TABLES=D:\dev\testdb\tables"
set "EXEC=%MYSQL_HOME%\bin\mysql.exe -h%HOST% -P%PORT% -u%USER% -p%PASSWORD% -D%DATABASE%<%TABLES%"

%EXEC%\deleteTables.sql
%EXEC%\1_ict_logs_table.sql
echo finished.