----- Original Message ----- > From: "Suporte Avanutri" <supor...@avanutri.com.br> > To: "Shafi AHMED" <shafi.ah...@sifycorp.com>, mysql@lists.mysql.com > 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 <mysqldatadir>/avanutri/obras.frm from disk and restart the service; the table will be gone. There shouldn't be any other files named obras.<something> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
