There is only ONE SLIM HOPE. Is your binary logging enabled ??? If yes, how far back ??
You could theoretically recreate the table from the binary logs up to the moment just before you accidentally dropped the table if the binary logs contain the moment you first created the table along with all insert, deletes and updates. Do you have binary logging turned ??? Run this in mysql client and see: show variables like 'log%'; ----- Original Message ----- From: Eric Lommatsch <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Tuesday, November 7, 2006 3:53:59 PM GMT-0500 US/Eastern Subject: Undelete a droped table Hello, I have accidently droped a table from one of my database's. The table was an innodb table. Is there anyway that I can recover the table or is that information gone for good if I don't have a current backup of that table? Thank you Eric H. Lommatsch Programmer MICRONix, Inc. 2087 South Grant Street Denver, CO 80210 Tel 303-777-8939 Fax 303-778-0378 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
