Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question