mysqlbinlog — Utility for Processing Binary Log Files 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 • --debug-info • --default-auth= plugin • --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” . A hint about which client-side authentication plugin to use. See Section 6.2.17, “Pluggable Authentication” . This option is available only if MySQL was built using  WITH_DEBUG . MySQL release binaries provided by Oracle are  not  built using this option. 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. Print some debugging information when the program exits. 607