MySQL Free install version script

Using MySQL often requires a free-to-install version (green version) of MySQL, began to search the Internet a lot, but it is not very useful.

Had to figure out their own, and now put out and share with you:

Install Startup services

[CPP]View PlainCopy

2. @ECHO OFF
4. If exist "%cd%/my.ini" goto startsrv
6. for/f%%i in (' net start ') do if%%i==mysql goto mysql_isrunning
8. Goto mysql_notrunning
10. : mysql_isrunning
12. echo "Found server!"
14. net stop MySQL
16. "%cd%"/bin/mysqld.exe-remove
18. Goto Createmyini
20. : mysql_notrunning
22. echo "Not found!"
24. : Createmyini
26. REM-------------------------------------------------------
28. REM Edit My.ini
30. Setlocal enabledelayedexpansion
32. Set realpath=
34. Set replaced=/
36. Set all=/
38. for/f "delims="%%i in (' CD ') does (
40. Set str=%%i
42. Set "str=!str:%replaced%=%all%!"
44. Set realpath=!str!
46. )
48. echo [Client] >>my.ini
50. echo Default-character-set=utf8 >>my.ini
52. Echo port=3306 >>my.ini
54. echo [Server] >>my.ini
56. echo Default-character-set=utf8 >>my.ini
58. Echo port=3306 >>my.ini
60. echo [MySQL] >>my.ini
62. echo Default-character-set=utf8 >>my.ini
64. echo [Mysqld] >>my.ini
66. Echo port=3306 >>my.ini
68. REM The following two sentences can be modified according to the actual situation
70. Echo Basedir=%realpath%/>>my.ini
72. Echo Datadir=%realpath%/data/>>my.ini
74. echo Default-character-set=utf8 >>my.ini
76. echo Default-storage-engine=innodb >>my.ini
78. Echo max_connections=100 >>my.ini
80. Echo query_cache_size=8m >>my.ini
82. Echo table_cache=256 >>my.ini
84. Echo tmp_table_size=9m >>my.ini
86. Echo myisam_max_sort_file_size=100g >>my.ini
88. Echo myisam_max_extra_sort_file_size=100g >>my.ini
90. Echo myisam_sort_buffer_size=18m >>my.ini
92. Echo key_buffer_size=11m >>my.ini
94. Echo read_buffer_size=64k >>my.ini
96. Echo read_rnd_buffer_size=256k >>my.ini
98. Echo sort_buffer_size=256k >>my.ini
100. Echo innodb_additional_mem_pool_size=2m >>my.ini
102. Echo Innodb_flush_log_at_trx_commit=1 >>my.ini
104. Echo innodb_log_buffer_size=1m >>my.ini
106. Echo innodb_buffer_pool_size=18m >>my.ini
108. Echo innodb_log_file_size=5m >>my.ini
110. Echo innodb_thread_concurrency=8 >>my.ini
112. REM Edit My.ini end.
114. REM---------------------------------------------------------------
116. "%cd%"/bin/mysqld.exe-install
118. : startsrv
120. net start MySQL
122. Pause
124. @ECHO on

Turn off Uninstall service

[CPP]View PlainCopy

1. @ECHO off
2. Set current_dir=%cd%
3. Set mysql_home=%current_dir%
4. net stop MySQL
5. Bin/mysqld.exe-remove
6. Del "%cd%"/my.ini

The key parts of the script are annotated, and if you have questions, you are welcome to discuss them together.

Also attach your own ready-to-install package (version 5.1.47), any version of the script is applicable

MySQL installation package (CSDN can not transfer large attachments, have to use this U egg, please carefully download)

If you already have the main file section, you can also put the bat file directly into the MySQL master directory

MySQL script. bat

http://blog.csdn.net/blpluto/article/details/5677457

MySQL Free install version script