Mysql binlog in not open when no backup data, delete a few data after the binlog open, can't recover data is like this?

CodePudding user response:

But need binlog is row format

CodePudding user response:

Can recover the data

CodePudding user response:

Don't open the binlog is impossible

CodePudding user response:

After opening binlog binlog can find is operating
So, if you want to restore open binlog removed after a few data, that is ok, if you are from the binlog restore all the data (i.e., open the data before), that's impossible

CodePudding user response:

In binlog open after deleting a few data, can recover data
Premise is must have a complete before,

CodePudding user response:

reference

rucypli: can but need binlog is row format

I didn't do perfect, before open open after resume execution delete interval, or log interval, the interval is a delete statement, how to restore??

CodePudding user response:

Need binlog is row format
Mysqlbinlog log file name - v - base64 - output=decode - rows
This can put you delete statement parsing out, you can see like this dongdong
# # # DELETE FROM ` xx `. ` xx `
# # # WHERE
# # # @ 1=1
Including the WHERE section contains all the column value, after get this, change the statement to
INSERT xx
SET
Line, write a small program or script implementation or easy