MySQL Forums
Forum List  »  Backup

Re: Help! - Innodb and MyISAM accidental DROP DATABASE - 112 tables gone forever?
Posted by: Oscar Rylin
Date: July 03, 2006 12:42PM

I really think a requirement for being able to post on this board should be having done a "Oops" and recovered from it, otherwise you're not much of an expert! :P

Casey: are you running with the binlog enabled? (e.g., are you running replication, or did you turn binlogging on by some other means?)

Using mysqlbinlog on the binary logs will be able to recreate the data.
I've had to do that once or twice, and while it is time consuming, it got us our data back.

I piped the output from mysqlbinlog into a file, then later on used ultraedit to trim it down to everything just before the "Oops".

Let me know if you need more help
/ oscar

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.