MySQL Table Exists (1050) but Doesn't Exist (1051)

Ran into an interesting issue this morning:

mysql> drop table RELATIONSHIP_TYPE;
ERROR 1051 (42S02): Unknown table 'relationship_type'

Which wouldn't be that weird except for:

mysql> CREATE TABLE `RELATIONSHIP_TYPE` (`relationshipTypeId` INT UNSIGNED AUTO_INCREMENT  NOT NULL, `name` VARCHAR(10) NOT NULL, `code` VARCHAR(2) NOT NULL, CONSTRAINT `PK_RELATIONSHIP_TYPE` PRIMARY KEY (`relationshipTypeId`)) ENGINE INNODB;
ERROR 1050 (42S01): Table 'relationship_type' already exists

After a fair amount of Google searching, I finally found an answer that implied I should try this:

$ mysqladmin flush-tables

Which seems to have solved the problem. I'm posting this in the hopes that the next person will have an easier time finding the answer.

Maven Growl

I've written up a small script for displaying Maven build notifications using Growl, and put it up on Github.