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

[Oscar Rylin]

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

Anyway,
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