1. 查看binlog配置
show variables like "%log_bin%";
OFF:关,ON:开
2. 开启配置:[mysqld]下
#Linux my.conf,my.ini windows
# binlog conf
log-bin = D:\log\mysql\bin_log\mysql-bin.log
expire-logs-days = 14
max-binlog-size = 500M
server-id = 1
3. 重启:
linux
service mysql restart
windows
如果报进程错误,可以用以下配置,然后再重新启动(原因:可能是版本低了)
在[mysqld]下
# binlog conf
log-bin = mysql-bin
expire-logs-days = 14
max-binlog-size = 500M
server-id = 1
其中,mysql-bin对应的路径在:
#Path to the database root
datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"
可以查看配置文件的参数datadir,即binlog的日志地址
4. 确认是否开启
show variables like '%log_bin%';