LinuxCommandLibrary

mysqlbinlog

Utility for processing MySQL binary log files.

TLDR

Show events from a specific binary log file

$ mysqlbinlog [path/to/binlog]
copy


Show entries from a binary log for a specific database
$ mysqlbinlog --database [database_name] [path/to/binlog]
copy


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]
copy


Show events from a binary log between specific positions
$ mysqlbinlog --start-position=[100] --stop-position=[200] [path/to/binlog]
copy


Show binary log from a MySQL server on the given host
$ mysqlbinlog --host=[hostname] [path/to/binlog]
copy

Copied to clipboard