mysqlbinlog

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.

Usage
mysqlbinlog [options] file_name ...

Standard Options Supported by mysqlbinlog
--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.

Options Specific to mysqlbinlog
--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.

--short-form, -s

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.