Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

Thanks!

share|improve this question
add comment

1 Answer

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;
http://www.percona.com/software/mysql-innodb-data-recovery-tools/

This page from the manual indicates that direct recovery of the data from the ibdata1 file is possible, if quite an involved manual process;
http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:extracting_the_desired_pages

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 percona.com/mysql-consulting/data-recovery (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
add comment

Your Answer

 
discard

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.