Re: Dropped table. . . Help Please

2005-12-14 Thread Johannes Franken
* Rick Dwyer <[EMAIL PROTECTED]> [2005-12-13 18:21 +0100]: > 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? If your mysqld writes binlogs (see "log-bin"-di

Re: Dropped table. . . Help Please

2005-12-13 Thread Gleb Paharenko
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

Dropped table. . . Help Please

2005-12-13 Thread Rick Dwyer
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 -- MySQL General Mailing List For list archive