Recently, I want to create a mysql master and back up data from.
Install Multiple mysql servers in a windows system. If you find that the installed version will overwrite the previous installation program, use the mysql server of noinstall version to record the installation steps. master. The backup cannot run ........
This is just one of the methods.
Install mysql in windows-noinstall so easy !!!
The procedure is as follows:
Setp1:
Download the current maximum version of The mysql-noinstall-5.1.58-win32
Setp2
Decompress the downloaded file to the local directory E :/
Creating a my. ini file configuration file under the root directory (mysql-5.1.58-win32) can also download attachments
Copy the content in the my-small.ini TO my. ini can be modified as needed, mainly the port number, log, directory or something. Look at it to understand
Setp3
Create startup. bat in the bin directory.
File Content: Pay attention to the name and Path
@ Echo off
Echo start mysql5master on localhost
Mysqld -- install mysql5master -- defaults-file = E: \ mysql-5.1.58-win32 \ my. ini
Net start mysql5master
Pause
Create stop. bat
Content:
@ Echo off
Echo stop mysql5master
Net stop mysql5master
Mysqld -- remove mysql5master
Pause
Setp4
Even now, you can test it.
Run cmd and switch to the bin directory to run startup. bat. if it is windows 7, you may not have the permission to create a service. Therefore, you 'd better use the administrator account to create a service. After running the service, you will see the system service installed in the windows service, the next operation is ......
Author: "huqing2010"