title: MySQL InnoDB tables are missing and not counted in database structure
body: <p>I have a serious problem in my MySQL tables , once there were InnoDB tables which were IN USE and now are somehow hidden </p>
  
  <p>look at this [pic] <em>*Link removed</em> - the number of tables in heading is 79 and actual counted number is 74.</p>
  
  <p>these tables are those that were IN USE</p>
  
  <p>I don't have any recent backup of my database , so this would game of life and death for me </p>
  
  <p>I checked my VPS, I found them at /etc/lib/mysql/db_name/.</p>
  
  <p><strong>EDIT :</strong></p>
  
  <p>I Searched around internet and I found out that every table should have 3 files related to it.</p>
  
  <p>For example, the table <code>table_users</code> has:</p>
  
  <pre><code> -- table_users.frm
   -- table_users.MYD
   -- table_users.MYI
  </code></pre>
  
  <p>and for those hidden table , there are only .frm files and the other two files of a table are missing.</p>
  
  <p><strong>I should change my question to: How to recover a innodb table from a .frm file?</strong></p>