@echo off
:init
set /p fileName= 请选择导入sql文件名:
set fiilPath=G:\%fileName%
set mysqlUse=db_game
set serverId=1
set ip=192.168.2.100
:start
if exist %fiilPath% (
echo.
) else (
echo 不存在文件:%fiilPath%
goto cho
)
echo %mysqlUse%开始导入%fileName%
mysql -h%ip% -uroot -p123456 %mysqlUse% < %fiilPath% > mysql_to_trunk.log 2>&1
echo.
set /p logMsg=<mysql_to_trunk.log
if /i "%logMsg%"=="" ( mysql -h%ip% -uroot -p123456 -e"update player set server_id = %serverId%, channel ='' " %mysqlUse%
set logMsg=导入成功 )
echo %fileName%">导入"%mysqlUse%数据结果 %logMsg%
:cho
echo.
echo ==========================================
echo 1. 重新导入
echo 2. 重新输入导入文件名
echo 其他退出
echo ==========================================
set choice=
set /p choice= 请选择:
:router
if /i "%choice%"=="1" goto start
if /i "%choice%"=="2" goto init
pause
注意mysql 要配置好环境变量,不然要进入对应的mysql.exe的执行目录执行