----- 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
> 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
