If you database contained MyISAM tables, you should prevent any access
to the partition (or logical disk in Windows) and recover deleted files
(*.MYI, *.MYD, *.frm). I'm not sure what to do with InnoDB tablespace
(not per-file), but certainly you should shutdown MySQL and copy ibdata
files to the safe place. Than read InnoDB parts of MySQL Internals to
find out the way to how recover your data.
Rick Dwyer wrote:
> I made a major mistake with MySQL 4.1.x. While using Navicatt I dropped
> my database when I meant to drop a table. Other than backups which are
> not that up to date, is there an undo?
> Help here is greatly appreciated.
> Thanks, I'm desperate.
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET