Environment: Windows 2008 R2, MySQL 5.051b
Two servers:
- server1: 192.168.2.8
- server2: 192.168.2.9
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 Command Line Client
mysql > show master status;
result
Empty set (0.00 sec)
However, we cannot find and mysql.bin in mySQL directory and we find the binary logs are disabled.
How should I enable the binary log?
