搜索版

  1. @echo off & setlocal
  4. :loop
  5. set /p answer=Do you want to continue (y/n)
  6. echo You chose: %answer%
  7. if /i {%answer%}=={y} goto :mysqlName
  8. if /i {%answer%}=={n} goto :no
  9. echo.
  10. echo.
  11. echo Invalid selection, try again&&goto :mysqlName
  13. rem 选择mysqld.exe 的新名字
  14. :mysqlName
  15. echo ================ 选择mysql版本 ===============
  16. echo -------------------------------------
  17. echo 1.  mysqld56
  18. echo 2.  mysqld57
  19. echo 3.  mysqld80
  20. echo ==========PRESS '0' TO QUIT==========
  21. echo.
  22. set inputn=
  23. set /p inputn=Please select a number:
  24. if /i '%inputn%'=='1' goto mysqld56s
  25. if /i '%inputn%'=='2' goto mysqld57s
  26. if /i '%inputn%'=='3' goto mysqld80s
  27. if /i '%inputn%'=='0' goto end
  28. echo.
  29. echo.
  30. rem 输入错误跳回 input
  31. echo wrong number, try it again&&goto :loop
  33. :mysqld56s
  34. set setMysql=mysqld56
  35. goto search
  36. :mysqld57s
  37. set setMysql=mysqld57
  38. goto search
  39. :mysqld80s
  40. set setMysql=mysqld80
  41. goto search
  46. rem 指定待搜索的文件
  47. :search
  48. echo 正在搜索，请稍候...
  49. for %%a in (C D E F G H I J K L M N O P Q R S T U V W X Y Z) do (
  50.   if exist %%a:\ (
  51.     for /f "delims=" %%b in ('dir /a-d /s /b "%%a:\*%setMysql%.exe" 2^>nul') do (
  52.       if /i "%%~nxb" equ "%setMysql%.exe" (
  53.         echo 搜索结束，文件路径为：%%b
  54.         for %%a in (%%b) do (
  55.                 echo %%~nxa
  56.                 set fileName=%%~nxa
  57.                 )
  58.         set currentDirss=%%b
  59.         goto searchOk
  60.       )
  61.     )
  62.   )
  63. )
  65. :searchOk
  66. set isNull=%currentDirss%
  67. if "%isNull%"=="" (
  68.     echo 搜索的文件不存在
  69.     goto end
  70. ) else (    
  71.     goto yes
  72. )
  74. :yes
  75. echo ================ 选择mysql功能 ===============
  76. echo.
  77. set currentDir=%currentDirss:~0,-13%
  78. set drives=%currentDirss:~0,2%
  79. SET dataFolder=%currentDir:~0,-3%data
  80. echo 查看mysql路径%currentDir%
  81. echo 启动的文件名：%fileName%
  82. echo cd 路径：%currentDir% %drives%
  83. echo data文件夹路径：%dataFolder%
  84. echo.
  85. echo -------------------------------------
  86. echo 1.  启动mysql 1
  87. echo 2.  进入mysql 2
  88. echo 3.  结束进程mysql 3
  89. echo ==========PRESS '0' TO QUIT==========
  90. echo.
  91. echo.
  93. set input=
  94. set /p input=Please select a number:
  95. if /i '%input%'=='1' goto startMysql
  96. if /i '%input%'=='2' goto goMysql
  97. if /i '%input%'=='3' goto killMysql
  98. if /i '%input%'=='0' goto end
  99. echo.
  100. echo.
  101. rem 输入错误跳回 input
  102. echo wrong number, try it again&&goto :mysqlName
  106. :startMysql
  107. echo.
  108. call taskkill /f /im %fileName%
  109. if %errorlevel% == 0 (
  110. 　echo 杀死%setMysql%进程成功
  111. ) else (
  112. 　echo 杀死%setMysql%进程失败
  113. )
  114. echo.
  115. echo Starting %setMysql% ...
  116. if exist %dataFolder% (
  117.     rem 目录data已存在，无需创建
  118.     echo 目录%dataFolder%目录已存在，无需创建！
  119.     goto startMysqlSucceed    
  120. ) else (
  121.     rem 创建data目录，使用复制方法
  122.     echo %dataFolder%目录不存在，已创建该目录！
  123.     md %dataFolder%
  124.     rem 睡3秒创建文件夹
  125.     timeout /T 3 /NOBREAK    
  126.     rem 睡醒了
  127.     cd /d %currentDir%
  128.     call %setMysql% --initialize-insecure --console && (goto startMysqlSucceed) || goto startMysqlFailed                
  129. )
  131. :startMysqlSucceed
  132. rem 睡三秒
  133. timeout /T 3 /NOBREAK
  134. cd /d %currentDir%
  135. echo 当前路径 %cd%
  136. start %fileName%
  137. echo 启动%setMysql%成功
  138. echo.
  139. echo.
  140. goto loop2
  142. :startMysqlFailed
  143. echo 初始化失败 删除文件夹
  144. rd /s /q %dataFolder%
  145. goto end
  147. :goMysql
  148. echo.
  149. echo.
  150. cd /d %currentDir%
  151. echo 当前路径 %cd%
  152. call mysql
  153. if %errorlevel% == 0 (
  154. 　echo 启动%setMysql%命令行成功
  155. ) else (
  156. 　echo 启动%setMysql%命令行失败
  157. )
  158. echo.
  159. echo.
  160. goto loop2
  162. :killMysql
  163. echo.
  164. echo 当前路径 %cd%
  165. echo.
  166. call taskkill /f /im %fileName%
  167. if %errorlevel% == 0 (
  168. 　echo 杀死%setMysql%进程成功
  169. ) else (
  170. 　echo 杀死%setMysql%进程失败
  171. )
  172. echo.
  173. echo.
  174. goto loop2
  177. :loop2
  178. echo ================ mysql ===============
  179. echo -------------------------------------
  180. echo 1.  选择mysql版本 1
  181. echo 2.  选择mysql功能 2
  182. echo ==========PRESS '0' TO QUIT==========
  183. echo.
  184. set input=
  185. set /p input=Please select a number:
  186. if /i '%input%'=='1' goto mysqlName
  187. if /i '%input%'=='2' goto yes
  188. if /i '%input%'=='0' goto end
  189. echo.
  190. echo.
  191. rem 输入错误跳回 input
  192. echo wrong number, try it again&&goto :loop
  197. goto end
  198. :no
  199. :end
  200. echo Good-bye!
  202. rem pause 
  203. endlocal & @echo on

指定路径版

  1. @echo off & setlocal
  4. :loop
  5. set /p answer=Do you want to continue (y/n)
  6. echo You chose: %answer%
  7. if /i {%answer%}=={y} goto :mysqlName
  8. if /i {%answer%}=={n} goto :no
  9. echo.
  10. echo.
  11. echo Invalid selection, try again&&goto :mysqlName
  13. rem 选择mysqld.exe 的新名字
  14. :mysqlName
  15. echo ================ 选择mysql版本 ===============
  16. echo -------------------------------------
  17. echo 1.  mysqld56
  18. echo 2.  mysqld57
  19. echo 3.  mysqld80
  20. echo ==========PRESS '0' TO QUIT==========
  21. echo.
  22. set inputn=
  23. set /p inputn=Please select a number:
  24. if /i '%inputn%'=='1' goto mysqld56s
  25. if /i '%inputn%'=='2' goto mysqld57s
  26. if /i '%inputn%'=='3' goto mysqld80s
  27. if /i '%inputn%'=='0' goto end
  28. echo.
  29. echo.
  30. rem 输入错误跳回 input
  31. echo wrong number, try it again&&goto :loop
  33. :mysqld56s
  34. set setMysql=mysqld56
  35. set fileName=%setMysql%.exe
  36. set currentDirss=D:\app\S_mysql\mysql-5.6.23-winx64\bin\%fileName%
  37. goto yes
  38. :mysqld57s
  39. set setMysql=mysqld57
  40. set fileName=%setMysql%.exe
  41. set currentDirss=D:\app\S_mysql\mysql-5.7.31-winx64\bin\%fileName%
  42. goto yes
  43. :mysqld80s
  44. set setMysql=mysqld80
  45. set fileName=%setMysql%.exe
  46. set currentDirss=D:\app\S_mysql\mysql-8.0.21-3336\bin\%fileName%
  47. goto yes
  52. :yes
  53. echo ================ 选择mysql功能 ===============
  54. echo.
  55. set currentDir=%currentDirss:~0,-13%
  56. set drives=%currentDirss:~0,2%
  57. SET dataFolder=%currentDir:~0,-3%data
  58. echo 查看mysql路径%currentDir%
  59. echo 启动的文件名：%fileName%
  60. echo cd 路径：%currentDir% %drives%
  61. echo data文件夹路径：%dataFolder%
  62. echo.
  63. echo -------------------------------------
  64. echo 1.  启动mysql 1
  65. echo 2.  进入mysql 2
  66. echo 3.  结束进程mysql 3
  67. echo ==========PRESS '0' TO QUIT==========
  68. echo.
  69. echo.
  71. set input=
  72. set /p input=Please select a number:
  73. if /i '%input%'=='1' goto startMysql
  74. if /i '%input%'=='2' goto goMysql
  75. if /i '%input%'=='3' goto killMysql
  76. if /i '%input%'=='0' goto end
  77. echo.
  78. echo.
  79. rem 输入错误跳回 input
  80. echo wrong number, try it again&&goto :mysqlName
  84. :startMysql
  85. echo.
  86. call taskkill /f /im %fileName%
  87. if %errorlevel% == 0 (
  88. 　echo 杀死%setMysql%进程成功
  89. ) else (
  90. 　echo 杀死%setMysql%进程失败
  91. )
  92. echo.
  93. echo Starting %setMysql% ...
  94. if exist %dataFolder% (
  95.     rem 目录data已存在，无需创建
  96.     echo 目录%dataFolder%目录已存在，无需创建！
  97.     goto startMysqlSucceed    
  98. ) else (
  99.     rem 创建data目录，使用复制方法
  100.     echo %dataFolder%目录不存在，已创建该目录！
  101.     md %dataFolder%
  102.     rem 睡3秒创建文件夹
  103.     timeout /T 3 /NOBREAK    
  104.     rem 睡醒了
  105.     cd /d %currentDir%
  106.     call %setMysql% --initialize-insecure --console && (goto startMysqlSucceed) || goto startMysqlFailed                
  107. )
  109. :startMysqlSucceed
  110. rem 睡三秒
  111. timeout /T 3 /NOBREAK
  112. cd /d %currentDir%
  113. echo 当前路径 %cd%
  114. start %fileName%
  115. echo 启动%setMysql%成功
  116. echo.
  117. echo.
  118. goto loop2
  120. :startMysqlFailed
  121. echo 初始化失败 删除文件夹
  122. rd /s /q %dataFolder%
  123. goto end
  125. :goMysql
  126. echo.
  127. echo.
  128. cd /d %currentDir%
  129. echo 当前路径 %cd%
  130. call mysql
  131. if %errorlevel% == 0 (
  132. 　echo 启动%setMysql%命令行成功
  133. ) else (
  134. 　echo 启动%setMysql%命令行失败
  135. )
  136. echo.
  137. echo.
  138. goto loop2
  140. :killMysql
  141. echo.
  142. echo 当前路径 %cd%
  143. echo.
  144. call taskkill /f /im %fileName%
  145. if %errorlevel% == 0 (
  146. 　echo 杀死%setMysql%进程成功
  147. ) else (
  148. 　echo 杀死%setMysql%进程失败
  149. )
  150. echo.
  151. echo.
  152. goto loop2
  155. :loop2
  156. echo ================ mysql ===============
  157. echo -------------------------------------
  158. echo 1.  选择mysql版本 1
  159. echo 2.  选择mysql功能 2
  160. echo ==========PRESS '0' TO QUIT==========
  161. echo.
  162. set input=
  163. set /p input=Please select a number:
  164. if /i '%input%'=='1' goto mysqlName
  165. if /i '%input%'=='2' goto yes
  166. if /i '%input%'=='0' goto end
  167. echo.
  168. echo.
  169. rem 输入错误跳回 input
  170. echo wrong number, try it again&&goto :loop
  175. goto end
  176. :no
  177. :end
  178. echo Good-bye!
  180. rem pause 
  181. endlocal & @echo on