mysqlbinlog
Utility for processing MySQL binary log files. More information: https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html.
- Show events from a specific binary log file:
mysqlbinlog
path/to/binlog
- Show entries from a binary log for a specific database:
mysqlbinlog --database
database_name
path/to/binlog
- Show events from a binary log between specific dates:
mysqlbinlog --start-datetime='
2022-01-01 01:00:00' --stop-datetime='
2022-02-01 01:00:00'
path/to/binlog
- Show events from a binary log between specific positions:
mysqlbinlog --start-position=
100 --stop-position=
200
path/to/binlog
- Show binary log from a MySQL server on the given host:
mysqlbinlog --host=
hostname
path/to/binlog