Windows Mysql Server Restart, log-bin path configuration

Windows Mysql Server restart, log-bin path configurationCategory: MySQL database 2014-03-16 14:49 1313 People read comments (0) favorite reports Mysqlmysql servermysql Restart the Windows command restart mysqlmysql log configuration

CMD, run the following command:

NET stop < service name >
NET start < service name >

Note:< service name > usually defaults to: MySQL

That
net stop MySQL
net start MySQL

Note:

How to view the service name:

On the desktop, right-click Computers, select Manage, select services and Applications, services: In the service to find the name and MySQL corresponding, in general, it should be the service name of MySQL server. such as Mysql56 and so on.

To turn off and turn on the service, in general, CMD is "opened as an administrator"

Under Windows systems, when configuring directory locations for MySQL's My.ini log-bin and so on, assume that you want to configure the Log-bin log to the Mysqllog file for the D drive as Binlog. You can configure the following:

[Mysqld]

log-bin= "D:\mysqllog/binlog" Note: The last path here is "/" instead of "\" on the Windows file system

Windows Mysql Server Restart, log-bin path configuration