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}}
License and Disclaimer
The content on this page is copyright © 2014—present the tldr-pages team and contributors.This page is used with permission under Creative Commons Attribution 4.0 International License.
While we do attempt to make sure content is accurate, there isn't a warranty of any kind.