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 ...  

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.

High Performance MySQL: Optimization, Backups, Replication, and More
ISBN: 0596101716
EAN: 2147483647
Year: 2003
Pages: 188

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: