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?
mysql> DROP TABLE imports.ncaa_passing_statistics; ERROR 1051 (42S02): Unknown table 'ncaa_passing_statistics' mysql> SELECT * FROM imports.ncaa_passing_statistics; ERROR 1146 (42S02): Table 'imports.ncaa_passing_statistics' doesn't exist mysql> CREATE TABLE imports.ncaa_passing_statistics (id INT); ERROR 1050 (42S01): Table '`imports`.`ncaa_passing_statistics`' already exists mysql>