Answer the question
In order to leave comments, you need to log in
Database recovery by ibdata1?
The situation is very simple. The database was accidentally deleted.
Yes, we know you need to keep a backup and so on, but the situation is that there are no backups.
Is it possible to somehow restore the database using only ibdata1. If you climb in it, you can see the data, but we still haven’t figured out how to decipher some of them.
Searched, studied many forums, and methods, so far nothing has helped.
This don't suggest habrahabr.ru/blogs/mysql/125358/ didn't work either.
There was hope for Habrahabr. Thanks in advance
Answer the question
In order to leave comments, you need to log in
Hello,
www.percona.com/docs/wiki/innodb-data-recovery-tool
www.percona.com/docs/wiki/innodb-data-recovery-tool
: mysql-data-recovery:start
launchpad.net/ percona-data-recovery-tool-for-innodb
A little time passed, some software solution was made.
One table was completely restored from ibdata1 information only.
If with the help of it we can recover ALL the information, we will lay out how it turned out.
This helped a little :)) a little extra programming and everything is buzzing.
Restored all data, except for very dynamic tables so far. We’ll deal with them a little later, because the head didn’t really work after a sleepless night, and I wanted to sleep
Later we will describe, we will try in detail, everything that happened that night) I think it will be useful for many to see the solution.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question