In case of Database Recovery after unexpected data corruption, list some common used scenarios of mysqlbinlog for processing binary log files.
Display Row Events
Convert binary events to SQL statements, DDL output will be displayed as raw statement, DML output will be displayed as lines beginning with
###, those are “pseudo-SQL” statements which are not executable.
For DML pseudo-SQL statements, they do not correspond exactly to the original SQL statements that generated the events, The original column names are lost and replaced by
@*N*, where N is a column number.
Also if you are using multi character set data, those character set information is not available in the display.