D
D
Dzen_Marketing2012-08-30 16:46:32
MySQL
Dzen_Marketing, 2012-08-30 16:46:32

Do I need a topic about the experience of restoring MySQL (InnoDB) with a bonus?

Briefly
Recovery of rows after DELETE FROM table;

Redmine
was spinning for a long time, project A and its subprojects B, C, D, E were spinning there.
On Monday morning I needed to delete project B, I deleted it, switched to tickets, I see some tickets are missing.
I went back to projects - project B is in place, but the rest are missing. To say that this is ambets is to say nothing.
I don't know if it's a bug or somehow cunningly managed to delete everything with one click, but:
-The backups were quite old.
-Binary logs were not kept.
Google says that recovery is not possible in such options.
As a result, the data, though not all, but it's a matter of time, with the help of Perkon's docks, Perkon's data recovery utility and some kind of mother, were pulled out of the ibdata1 file where they were still alive and then imported into the database.

Answer the question

In order to leave comments, you need to log in

3 answer(s)
E
EugeneOZ, 2012-08-30
@Dzen_Marketing

Yeah, that's cool.

L
lubezniy, 2012-08-30
@lubezniy

I think a top is needed.

V
v2t, 2012-08-31
@v2t

It will be interesting to read. Recently I myself tried to recover data using "Percona Data Recovery Tool for InnoDB", but the case was a little different. Throw off the link to the topic here after writing. Thank you.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question