MySQL binlog读取

Question

我在Windows7上安装了Windows5.5，我是按常规安装的。我的所有日志都存储在C:\ProgramData\MySQL\MySQL Server 5.5\data\mysql-bin.00057目录下，例如

当我尝试运行mysqlbinlog mysqlbin.000057时，它显示错误2未找到文件

我甚至尝试过mysqlbinlog C:\ProgramData\MySQL\MySQL Server5.5\data\mysql-bin.000057，它也显示找不到该文件。

我想知道如何使用binlog通过mysqlbinlog来读取这些文件

Answer 1

MySQL服务器设置

server-id   = 100 
log_bin = /var/log/mysql/mysql-bin.log 
expire_logs_days = 12
max_binlog_size = 120M 
binlog-format = row // very very important for read, update and delete

来源

https://github.com/aliozyildirim/mysql-binlog-reader-and-cdc/