Nov 18, 2018

mysqlbinlog - Utility for Processing Binary Log Files for MySQL

MySQL server's binary log consists of files containing “events” that describe modifications to database contents. The server writes these files in binary format. To display their contents in text format, use the mysqlbinlog utility. You can also use mysqlbinlog to display the contents of relay log files written by a slave server in a replication setup because relay logs have the same format as binary logs.

Example usage:

mysqlbinlog mysql-bin.000212 --start-position=589388355 | mysql  --login-path=db5

mysqlbinlog binlog.0000088 --start-datetime="2015-08-08 18:08:08" | mysql --login-path=db5 --force