Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've made a stupid mistake of backing up the wrong database for the whole time, and an accident just happened leaving my entire database destroyed. The only thing that I have is an ibdata1 file, I am just wondering if there are any tools that can allow me to make more sense out of an ibdata file to do as much recovery as possible? This is just a personal project so it's not necessary to get everything back. I just hope that I can get as much back as I can and it seems like ibdata1 contains some info that I need.


share|improve this question
up vote 3 down vote accepted

I am not sure if this is enough for an answer to the question, but the go-to dudes for mysql tools are percona, and they have a innodb recovery toolkit;

This page from the manual indicates that direct recovery of the data from the ibdata1 file is possible, if quite an involved manual process;

share|improve this answer
Thanks! This is exactly what I need! – gtr32x Feb 24 '12 at 10:51
if you are deeply in the mire, i think they will recover it for you (haha, I don't work for percona or anything, I just think their stuff is very cool) – Tom H Feb 24 '12 at 11:07
Hahah, not yet willing to shell out a huge amounts for the recovery, so I'll give it a try myself first. But thanks for the heads up! – gtr32x Feb 24 '12 at 20:22

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.