mysqlbinlog --database=test  does not output the first two INSERT  statements because there is no default database. It outputs the three INSERT  statements following USE test , but not the three INSERT  statements following USE db2 . 

mysqlbinlog --database=db2  does not output the first two INSERT  statements because there is no default database. It does not output the three INSERT  statements following USE test , but does output the three INSERT  statements following USE db2 . 

Row-based logging. mysqlbinlog  outputs only entries that change tables belonging to db_name . The default database has no effect on this. Suppose that the binary log just described was created using row-based logging rather than statement-based logging. mysqlbinlog --database=test  outputs only those entries that modify t1  in the test database, regardless of whether USE  was issued or what the default database is. 

If a server is running with binlog_format  set to MIXED  and you want it to be possible to use mysqlbinlog  with the --database  option, you must ensure that tables that are modified are in the database selected by USE . (In particular, no cross-database updates should be used.) 

When used together with the --rewrite-db  option, the --rewrite-db  option is applied first; then the --database  option is applied, using the rewritten database name. The order in which the options are provided makes no difference in this regard. 

• --debug[= debug_options ] , -# [ debug_options ] 

Write a debugging log. A typical debug_options  string is d:t:o, file_name . The default is d:t:o,/ tmp/mysqlbinlog.trace . 

This option is available only if MySQL was built using WITH_DEBUG . MySQL release binaries provided by Oracle are not  built using this option. 

• --debug-check 

Print some debugging information when the program exits. 

This option is available only if MySQL was built using WITH_DEBUG . MySQL release binaries provided by Oracle are not  built using this option. 

• --debug-info 

Print debugging information and memory and CPU usage statistics when the program exits. 

This option is available only if MySQL was built using WITH_DEBUG . MySQL release binaries provided by Oracle are not  built using this option. 

• --default-auth= plugin 

A hint about which client-side authentication plugin to use. See Section 6.2.17, “Pluggable Authentication” . 

• --defaults-extra-file= file_name 

Read this option file after the global option file but (on Unix) before the user option file. If the file does not exist or is otherwise inaccessible, an error occurs. If file_name  is not an absolute path name, it is interpreted relative to the current directory. 

For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . 

