N
N
Nikolay Melnik2011-10-28 02:31:12
MySQL
Nikolay Melnik, 2011-10-28 02:31:12

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

3 answer(s)
Y
Yuriy Andamasov, 2011-10-28
@NikolayMelnik

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

N
Nikolay Melnik, 2011-10-28
@NikolayMelnik

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.

N
Nikolay Melnik, 2011-10-28
@NikolayMelnik

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 question

Ask a Question

731 491 924 answers to any question