View the content method in the Binlog log restored by MySQL

Once you've identified the data you need to see with mysqlbinlog, you can use more to see:

[Email protected] data]# more Recover_sakila.sql | grep--ignore-case-e ' Insert '-a2-b2 | Grep Yoon

If the table name contains Yoon_log,yoon_order, just want to export the Yoon table, +-W
[Email protected] data]# more Recover_sakila.sql | grep--ignore-case-e ' Insert '-a2-b2 | Grep-w Yoon > Yoon.sql

Insert into Yoon (name) VALUES (' Yoon ')
Insert into Yoon (name) VALUES (' AAA ')

You can clearly see all of the INSERT INTO statement, if the statement contains a longer HTML content, you cannot find the full UPDATE statement to the command:

Cat Recover_sakila.sql | Grep-i ' Update Yoon '-a60-b60 | Grep-i ' Update Yoon '-a60-b60 > Recover_sakila.sql

With SED you can filter all statements and not be truncated:

Sed-n "/insert into yoon/,/;/p" Yoon.sql |sed ' s#\/\*!\*\/## '

View the content method in the Binlog log restored by MySQL