----- Original Message -----
> From: "Suporte Avanutri" <suporte2@stripped>
> To: "Shafi AHMED" <shafi.ahmed@stripped>, 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
> 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