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 .
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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: