from : http://www.cnblogs.com/edrh/archive/2007/09/04/881054.html

1.首先確認你日志是否啟用了
mysql>show variables like 'log_bin';
2.如果啟用了，即ON
那日志文件就在mysql的安裝目錄的data目錄下
3.怎樣知道當前的日志
mysql> show master status;                                                                                                                                               
4.看二進制日志文件用mysqlbinlog
shell>mysqlbinlog mail-bin.000001
或者shell>mysqlbinlog mail-bin.000001 | tail

Windows 下用類似的命令。