* 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"-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 mc. Please let us know, if you need help with these tools. Good luck! -- Johannes Franken MySQL Certified Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
