1.首先确认你日志是否启用了
mysql>show variables like 'log_bin';
mysql>show variables like 'log';
2.如果启用了,即ON
如果没有启用,即OFF,
要修改my.cnf
# The MySQL server
[mysqld]
# Uncomment the following if you want to log updates
log-bin
log
那日志文件就在mysql的安装目录的data目录下
3.怎样知道当前的日志
mysql> show master status; 4.看二进制日志文件用mysqlbinlog
shell>mysqlbinlog mail-bin.000001
或者shell>mysqlbinlog mail-bin.000001 | tail
Windows 下用类似的命令