I am trying to restore some lost data , but I am not having its backup .So I am trying to restore from the binary log .Please explain how to restore from the binary log in mysql .
Do you know from which binlog files you need to restore and how many binlog files there are?
If it's a single file you can recover using:
If it's multiple files then just extract all content to one .sql file and directly restore it:
To append second binlog content to allbinlof.sql file use below command:
You can also exclude certain statements using option of mysqlbinlog. Try this below for options:
You can use -v option to make .sql file in READABLE format.
Use below steps to restore data from binary logs or use this link to understand restoration process: MySQL Binary Log Restoration
First, restore database from the latest backup
Then do either of: