List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:December 13 2005 5:46pm
Subject:Re: Dropped table. . . Help Please
View as plain text  
Hello.

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.
> Rick
> 
> 


-- 
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
       <___/   www.mysql.com



Thread
Dropped table. . . Help PleaseRick Dwyer13 Dec
  • Re: Dropped table. . . Help PleaseGleb Paharenko13 Dec
  • Re: Dropped table. . . Help PleaseJohannes Franken14 Dec