title: Mysql: Table exists and doesn't exist
body: <p>I had a table that got deleted ("filescan").  When I go to the data directory and list the files using ls, the name is not there - so it's really gone.  But in mysql, I get this:</p>
  
  <pre><code>mysql&gt; select * from filescan;
  ERROR 1146 (42S02): Table 'db1.filescan' doesn't exist
  mysql&gt; create table filescan (id int);
  ERROR 1813 (HY000): Tablespace '`db1`.`filescan`' exists.
  mysql&gt; 
  </code></pre>
  
  <p>I assume that somewhere there's a table that is telling mysql that this file exists, when in fact it doesn't.  Any suggestions for dealing with this example of Schödinger's mysql table?</p>