InnoDB: Getting rid of a phantom table
The table still exists in the InnoDB dictionary. It's similar to how MySQL left temporary tables after a failed ALTER.

I found that the easiest way to remove an entry from the dictionary tables is to drop whole database. Obviously you want to keep the data, so moving it to a temporary database will work. Anyways, the steps are:


Create an empty temporary database. Let it be tmp1234. 
Move all tables from the original database to tmp1234. 
Drop the original database (it’s empty by now, all tables are in tmp1234). 
Create the original database again.
Move all tables from the temporary database to the original one.
Drop the empty temporary database.


Check out https://twindb.com/resolving-error-1050-42s01-at-line-1-table-already-exists/ for some background.