MySQL Forums
Forum List  »  Data Recovery

Re: Recover dropped database
Posted by: Oli Sennhauser
Date: May 09, 2010 11:41AM

Hi Mark,

2 possibilities come to my mind:

1. If they are MyISAM tables try to do a file system un-delete.
2. If they are InnoDB afaik the drop table does just set a deleted flag in the data dictionary of innodb.

So if you do, close in time, an un-delete (file system) or a un-delete (I have to figure out how) in InnoDB the tables could probably be recovered.

Best regards,
Oli
--

FromDual - Independent and neutral MySQL consulting in Europe!

Oli Sennhauser
Rebenweg 6
CH - 8610 Uster / Switzerland

Mobile +41 79 830 09 33
e-Mail oli.sennhauser@fromdual.com
Website http://www.fromdual.com/
Skype fromdual

Options: ReplyQuote


Subject
Views
Written By
Posted
13288
April 20, 2010 06:49AM
Re: Recover dropped database
5069
May 09, 2010 11:41AM


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.