Re: Help! - Innodb and MyISAM accidental DROP DATABASE - 112 tables gone forever?

[Oli Sennhauser]

Hi Casey

Theoreticaly there are some ways. But it takes a lot of time and manpower without guaranteeing any results. It depends on the value of your data...

InnoDB: The datastructures could still be there (do a strings on the ibdata file). So one need a script which does a undelete.

MyISAM: You need to do a file recovery on OS side (undelete). Then it could work.

But all these things are ugly hacks and will not guarantee your data integrity.

What you should have done in the very first beginning:
* Stopp the server by power plug (this prevents writing the file buffer to disk and can corrupt MyISAM tables. In your case you will also loose at most 1 second of InnoDB data. You should not set innodb_flush_log_at_trx_commit=0 if you do not have a reason for).
* Start the server without mounting the data partitions.
* Make an image of your data partitions (dd if=/dev/... of=...)
* Mount these images and try recovery there...

Regards Oli