How can I remove references to tables after removing .frm files? So I had a bunch of csv files in my /var/lib/mysql/imports directory for importing into mysql tables I had created.  To clean up the folder I deleted all the files in the directory (incorrectly thinking it only contained .csv files).  The only problem was that the folder also stored table data from my imports database.  Now that I realized my error I was just going to recreate the database I did delete and re-import from the csv file.  However I cannot create the table again because mysql must have references to the table.  How can I remove this table completely so that I can simply recreate it and re-import the information?

Edit:

mysql&gt; DROP TABLE imports.ncaa_passing_statistics;
ERROR 1051 (42S02): Unknown table 'ncaa_passing_statistics'
mysql&gt; SELECT * FROM imports.ncaa_passing_statistics;
ERROR 1146 (42S02): Table 'imports.ncaa_passing_statistics' doesn't exist
mysql&gt; CREATE TABLE imports.ncaa_passing_statistics (id INT);
ERROR 1050 (42S01): Table '`imports`.`ncaa_passing_statistics`' already exists
mysql&gt;
Shut down mysql.  What files do you see?  Restart mysql; are things better now?

One possible fix is to CREATE a new table (with a different name), copy the .frm to somewhere else, drop the table, shutdown, copy the .frm back as the problematical table name, restart.