The mysqlbinlog utility displays the contents of a binary update log file in readable format. This program can read log files on the local host directly or connect to a remote server to read remote logs.
The format of binary update logs has changed from time to time. You may find it necessary to use a version of mysqlbinlog that is at least as recent as your server version to avoid compatibility problems.
mysqlbinlog [options] file_name ...
--debug --host --port --version --help --password --user
The --host, --password, --port, and --user options are used when you want to connect to a remote server to access its binary logs. Otherwise, mysqlbinlog reads local log files directly without connecting to a server.
--database=db_name, -d db_name,
Extract statements from the log file only for the named database. This option works only when reading local logs.
--offset=n, -o n
Skip the first n entries in the log file.
--position=n, -j n
Start reading the log file at position n.
--result-file=file_name, -r file_name
Write output to the named file.
Show only the statements in the log; omit any extra information in the log that is associated with the statements.
--table=tbl_name, -t tbl_name
Obtain a raw dump of the named table.