Consult the mysql data recovery problem-CodePudding

Mysql database was covered by the wrong operation data, how to restore the last time the raw data, before the database backup, urgent,

CodePudding user response:

Open the binlog? If there are any baidu binlog restore the database

CodePudding user response:

The

reference 1/f, February 16 response:

opens the binlog? If there are any baidu binlog restore database

Binlog opened, I'll see if feasible is not workable

CodePudding user response:

The

reference 1/f, February 16 response:

opens the binlog? If there are any baidu binlog restore database

Baidu has a variety of methods, did not dare to try, is there anyone to ensure feasible method

CodePudding user response:

reference zseno_0 reply: 3/f

Quote: reference 1/f, February 16 response:
opens the binlog? If there are any baidu binlog restore database

Baidu has a variety of methods, did not dare to try, is there anyone to ensure that the feasible method

Mysql I haven't used

@ ZJCXC

CodePudding user response:

Give you @ the bosses, and see if I can handle

CodePudding user response:

February 16 references 5 floor response:

@ the bosses to you, and see if I can deal with

Thank you thank you

you are all bosses

CodePudding user response:

No backup means that cannot use binlog back to the time point
If your binlog record mode is row (the default), the binlog will save by the operating data of original data, you can parse binlog content, then generate contrarian statement
Resolution (filter parameters can be specified time points, specific see mysqlbinlog -- help) :
Mysqlbinlog -v - base64 - output=decode - rows binlog file name & gt; The output file
Results file will contain similar is this information
The UPDATE
SET
.
WHERE
.
Corresponding updates, WHERE there is the old data, recovery of operation is to SET and WHERE change
The INSERT statement into the DELETE
The DELETE statement to INSERT, WHERE conditions are similar to the UPDATE, contains the complete old data

CodePudding user response:

refer to 7th floor ZJCXC - personal WeChat public namesake reply:

no backup means that cannot be used to restore the binlog time
If your binlog record mode is row (the default), the binlog will save by the operating data of original data, you can parse binlog content, then generate contrarian statement
Resolution (filter parameters can be specified time points, specific see mysqlbinlog -- help) :
Mysqlbinlog -v - base64 - output=decode - rows binlog file name & gt; The output file
Results file will contain similar is this information
The UPDATE
SET
.
WHERE
.
Corresponding updates, WHERE there is the old data, recovery of operation is to SET and WHERE change
The INSERT statement into the DELETE
The DELETE statement to INSERT, WHERE conditions are similar to the UPDATE, contains the complete old data

Is a long before the old backup files that covered now are using the new database, which is to generate the contrarian statement? Is in lane double-click covers the operation of hot standby for machine hosting the database,

CodePudding user response:

File cover, then have a headache, the file cover should be positive, but ask you binlog log contains a backup from the old from the beginning

CodePudding user response:

references 9 f ZJCXC - personal WeChat public namesake reply:

file cover, then have a headache, file cover should be positive, but for your binlog contains from old backup log

In recent days the binlog all saved