From: Johan De Meersman Date: January 24 2012 3:01pm Subject: Re: RES: Force drop table List-Archive: http://lists.mysql.com/mysql/226661 Message-Id: <3765cb4e-b165-413d-a86b-33eb91dd3432@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Suporte Avanutri" > To: "Shafi AHMED" , mysql@stripped > Sent: Tuesday, 24 January, 2012 3:43:36 PM > Subject: RES: Force drop table > > 120124 12:29:28 InnoDB: Error: table `avanutri/obras` does not exist in the InnoDB internal > InnoDB: data dictionary though MySQL is trying to drop it. > InnoDB: Have you copied the .frm file of the table to the > InnoDB: MySQL database directory from another database? That's a pretty good question it's asking :-) Earlier in your log it mentions that InnoDB wasn't shut down properly - did it crash while you were deleting that table, by any chance? Shut the service down, delete the file /avanutri/obras.frm from disk and restart the service; the table will be gone. There shouldn't be any other files named obras. if all is well. If you can, it is probably also a good idea to make a full dump of all the databases and reinitialize the InnoDB tablespaces - there may still be internal references or pages allocated to that table. Check the online manual for more information on doing that. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel