windows下mysql启动停止服务示例脚本

机子重装的时候,留着用!!

1.StartMySQL.bat

/***********************************************

cd /d %~dp0
@ECHO OFF

if exist "%cd%/my.ini" goto startsrv
for /f %%i in ('net start') do if %%i==MySQL goto MySQL_IsRunning
 goto MySQL_NotRunning

:MySQL_IsRunning
@echo "found Server!"
net stop mysql

%cd%/bin/mysqld.exe -remove

goto createmyini

:MySQL_NotRunning
@echo "not found!"

:createmyini
rem -------------------------------------------------------
rem edit my.ini

setlocal enabledelayedexpansion
set realpath=
set replaced=/
set all=/
for /f "delims=" %%i in ('cd') do (
    set str=%%i
    set "str=!str:%replaced%=%all%!"
    set realpath=!str!
)

@echo [client] >>my.ini
@echo default-character-set=utf8 >>my.ini
@echo port=3306 >>my.ini
@echo [server] >>my.ini
@echo default-character-set=utf8 >>my.ini
@echo port=3306 >>my.ini
@echo [mysql] >>my.ini
@echo default-character-set=utf8 >>my.ini

@echo [mysqld] >>my.ini
@echo port=3306 >>my.ini
@echo basedir=%realpath%/>>my.ini
@echo datadir=%realpath%/data/ >>my.ini
@echo default-character-set=utf8 >>my.ini
@echo default-storage-engine=INNODB >>my.ini
@echo max_connections=100 >>my.ini
@echo query_cache_size=8M >>my.ini
@echo table_cache=256 >>my.ini
@echo tmp_table_size=9M >>my.ini
@echo myisam_max_sort_file_size=100G >>my.ini
@echo myisam_max_extra_sort_file_size=100G >>my.ini
@echo myisam_sort_buffer_size=18M >>my.ini
@echo key_buffer_size=11M >>my.ini
@echo read_buffer_size=64K >>my.ini
@echo read_rnd_buffer_size=256K >>my.ini
@echo sort_buffer_size=256K >>my.ini
@echo innodb_additional_mem_pool_size=2M >>my.ini
@echo innodb_flush_log_at_trx_commit=1 >>my.ini
@echo innodb_log_buffer_size=1M >>my.ini
@echo innodb_buffer_pool_size=18M >>my.ini
@echo innodb_log_file_size=5M >>my.ini
@echo innodb_thread_concurrency=8 >>my.ini
rem edit my.ini end.
rem ---------------------------------------------------------------

%cd%/bin/mysqld.exe -install MySQL --defaults-file=%cd%/my.ini

:startsrv

net start MySQL

@ECHO ON
exit

/****************************************************

2.StopMySQL.bat(移动mysql服务)

/***************************************************

cd /d %~dp0
@ECHO off
Set CURRENT_DIR=%cd%

Set MYSQL_HOME=%CURRENT_DIR%

net stop mysql

bin/mysqld.exe -remove

del %cd%/my.ini