运行sql   show variables like 'log_bin';

如果Value 为 OFF 则未开启日志文件

如何开启mysql日志？

找到my,cnf 中 [mysqld]  添加如下

[mysqld]
# binlog 配置
log-bin = /usr/local/var/mysql/logs/mysql-bin.log
expire-logs-days = 14
max-binlog-size = 500M
server-id = 1
 
如果没有my.cnf  或者是集成的环境 找到my.ini 中 [mysqld]  添加如下
 
[mysqld]
# binlog 配置
log-bin = /usr/local/var/mysql/logs/mysql-bin.log
expire-logs-days = 14
max-binlog-size = 500M
server-id = 1
 
重启mysql后    show variables like 'log_bin';  Value 为 ON即可
 
查询binlog 变动信息   show binlog events;


以上是网上找的。以下是我的操作记录
phpStudy，mysql5.3
打开my.ini最后增加

# binlog 配置
log-bin="E:/binlog/mysql-bin.log"
expire-logs-days = 14
max-binlog-size = 20000M
server-id = 1