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.