MySQL binlog reading

Question

I installed MySQL 5.5 on Windows 7 I did it as a general install. All my logs are stored under the C:\ProgramData\MySQL\MySQL Server 5.5\data\mysql-bin.00057 for example

when I try to run mysqlbinlog mysqlbin.000057 it gives me error 2 file not found

I have even tried mysqlbinlog C:\ProgramData\MySQL\MySQL Server 5.5\data\mysql-bin.000057 it also says it can't find the file.

Just wondering how I can use the binlog to read these files using mysqlbinlog

What if you cd to directory first? cd C:\ProgramData\MySQL\MySQL Server 5.5\data — Antonios, Jul 16 '14 at 13:31

score 0 · Answer 1 · edited Dec 24 '18 at 11:54

0

MySQL server settings

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

Source

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

edited Dec 24 '18 at 11:54

executable

3,365
6
24
52

answered Dec 24 '18 at 11:03

Melih Sevim

930
6
9

this code records the log from the log database to the cdc database – Melih Sevim Dec 24 '18 at 22:57

MySQL binlog reading

1 Answers1