mysqlbinlog — Utility for Processing Binary Log Files BINLOG ’ fAS3SBMBAAAALAAAAC4BAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBgBAAAANgAAAGQBAAAQABEAAAAAAAEAA////AEAAAAFYXBwbGX4AQAAAARwZWFyIbIP ’/*!*/; ... # at 400 #080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F BINLOG ’ fAS3SBMBAAAALAAAAJABAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBkBAAAAKgAAALoBAAAQABEAAAAAAAEAA//4AQAAAARwZWFyIbIP ’/*!*/; shell>  mysqlbinlog -v  log_file ... # at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG ’ fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ== ’/*!*/; ### INSERT INTO test.t ### SET ### @1=1 ### @2=’apple’ ### @3=NULL ... # at 302 #080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F BINLOG ’ fAS3SBMBAAAALAAAAC4BAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBgBAAAANgAAAGQBAAAQABEAAAAAAAEAA////AEAAAAFYXBwbGX4AQAAAARwZWFyIbIP ’/*!*/; ### UPDATE test.t ### WHERE ### @1=1 ### @2=’apple’ ### @3=NULL ### SET ### @1=1 ### @2=’pear’ ### @3=’2009:01:01’ ... # at 400 #080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F BINLOG ’ fAS3SBMBAAAALAAAAJABAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBkBAAAAKgAAALoBAAAQABEAAAAAAAEAA//4AQAAAARwZWFyIbIP ’/*!*/; ### DELETE FROM test.t ### WHERE ### @1=1 ### @2=’pear’ ### @3=’2009:01:01’ To see the row events as comments in the form of “pseudo-SQL”  statements, run  mysqlbinlog  with the --verbose  or  -v  option. This output level also shows table partition information where applicable. The output contains lines beginning with  ### : Specify  --verbose  or  -v  twice to also display data types and some metadata for each column, and informational log events such as row query log events if the  binlog_rows_query_log_events  system variable is set to  TRUE . The output contains an additional comment following each column change: 619