MySQL Forums
Forum List  »  Backup

Re: Help! - Innodb and MyISAM accidental DROP DATABASE - 112 tables gone forever?
Posted by: Oli Sennhauser
Date: June 29, 2006 04:17AM

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

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.