环境:Windows 2008 R2,MySQL 5.051b
两台服务器:
server1> my.ini
[mysqld] server-id = 1 auto-increment-increment = 2 auto-increment-offset = 1 log-bin = mysql.bin bind-address = 0.0.0.0
server2> my.ini
[mysqld] server-id = 2 auto-increment-increment = 2 auto-increment-offset = 2 log-bin = mysql.bin bind-address = 0.0.0.0
mySQL命令行客户端
mysql > show master status;
结果
Empty set (0.00 sec)
但是,我们在mySQL目录下找不到mysql.bin,我们发现二进制日志是被禁用的。
我应该如何启用二进制日志?