Recovering data with MySQL binlog

1、 Data preparation

1、 The data are as follows ： common 28 Bar record

2、 Simulation delete ：DELETE FROM sys_dict_data WHERE dict_type=‘sys_oper_type’

2、 Use binlog Restore data

binlog Content view

1、 Use show binlog events： Not very friendly , You can refer to the second

2、 Use mysqlbinlog

1、 adopt binlog Get content and output to file

-d: Filter logs based on the name of the database
-o： Skip the former N Line logs
-r, --result-fil: Output the log to the specified file
–start-datetime: Read the log after the specified time , Time format ：yyyy-MM-dd HH:mm:ss
–stop-datetime: Read the log before the specified time , Time format ：yyyy-MM-dd HH:mm:ss
–start-position: Read the log from the specified location
–stop-position: Read to the specified location to stop
–base64-output： stay row Under format , Show fake sql sentence
-v, --verbose： Show fake sql sentence ,-vv It can be for sql Statement to add remarks

2、 By looking at sql, Inverse analysis insert Of sql Statement to recover