* Rick Dwyer <rdwyer@stripped> [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"-directive in my.cnf), you
can use mysqlbinlog to turn them into a mysqldump-style file of
SQL-statements, which you then feed to mysql.
If the dropped database contained MyISAM-tables, you might be able to
undelete those *.MYI, *.MYD and *.frm -files from your filesystem. Under
Linux you can use tools like e2undel and debugfs and certain versions of
Please let us know, if you need help with these tools.
MySQL Certified Professional