검색어: mysqlbinlog (영어 - 체코어)

invoke mysqlbinlog like this:
invoke mysqlbinlog like this:

mysqlbinlog [options] log _file ...
mysqlbinlog [options] log _file ...

mysqlbinlog supports the following options.
mysqlbinlog supports the following options:

shell > mysqlbinlog [options] log _file ...
shell > mysqlbinlog [options] log _file ...

to display their contents in text format, use the mysqlbinlog utility.
to display their contents in text format, use the mysqlbinlog utility.

the datetime value is relative to the local time zone on the machine where you run mysqlbinlog.
the datetime value is relative to the local time zone on the machine where you run mysqlbinlog.

you can also use mysqlbinlog to read relay log files written by a slave server in a replication setup.
you can also use mysqlbinlog to read relay log files written by a slave server in a replication setup.

normally, you use mysqlbinlog to read binary log files directly and apply them to the local mysql server.
normally, you use mysqlbinlog to read binary log files directly and apply them to the local mysql server.

display a hex dump of the log in comments, as described in the section called "mysqlbinlog hex dump format".
display a hex dump of the log in comments, as described in the section called "mysqlbinlog hex dump format".

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

with this option, if mysqlbinlog reads a binary log event that it does not recognize, it prints a warning, ignores the event, and continues.
with this option, if mysqlbinlog reads a binary log event that it does not recognize, it prints a warning, ignores the event, and continues.

the output from mysqlbinlog can be re-executed (for example, by using it as input to mysql) to reapply the statements in the log .
the output from mysqlbinlog can be re-executed (for example, by using it as input to mysql) to reapply the statements in the log .

to see the row events as comments in the form of "pseudo-sql" statements, run mysqlbinlog with the --verbose or -v option.
to see the row events as comments in the form of "pseudo-sql" statements, run mysqlbinlog with the --verbose or -v option.

because mysqlbinlog converts load data infile statements to load data local infile statements (that is, it adds local), both the client and the server that you use to process the statements must be configured to allow local capability.
because mysqlbinlog converts load data infile statements to load data local infile statements (that is, it adds local), both the client and the server that you use to process the statements must be configured to allow local capability.