Hello Albert. The log only contains table ids which can be mapped in the catalog to the tablename. But no user information is stored in the log only a timestamp. So the only information you can get is the time when the table was dropped.
You could look into the log and search for DropFile entries then you find some table ids. To find out which table id belongs to which tablename you have to recover an older data backup where the dropped table still existed into a new second database instance. There you can find out the table names for the table ids you previously found in the log. If you still want to this I have to give you more details for the usage of x_diagnose. Kind regards Uwe >-----Original Message----- >From: Beermann, Albert [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 09, 2005 9:24 AM >To: [email protected] >Subject: Lost a table ?? Urgently need help ! > >Hello Everybody ! > >My application run well until yesterday! >Today my users reported a lot of errors. >When I look at the database, I miss a table ?????? >Where can I start searching what happened ? >Is there a file(log,history,protocol) with informations when the table >was dropped and who has done this ???? (a tool to read,search such >file?) >Any other ideas ??? > >Any help welcomed >Albert > > > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
