How to Restore data from binary log How can I restore my files and photos from binary files?
Do you know from which binlog files you need to restore and how many binlog files there are?

Using mysqlbinlog utility we can view the binlog file content.

If it's a single file you can recover using:

mysqlbinlog /var/lib/mysql-bin.000016 | mysql –uroot –pReset123


If it's multiple files then just extract all content to one .sql file and directly restore it:

mysqlbinlog /var/lib/mysql-bin.000016 &gt; /logs/allbinlog.sql


To append second binlog content to allbinlof.sql file use below command:

mysqlbinlog /var/lib/mysql-bin.000016 &gt;&gt; /logs/allbinlog.sql


You can also exclude certain statements using option of mysqlbinlog. Try this below for options:

mysqlbinlog --help