title: Restore a corrupted table
body: <p>A few days ago my whole server decided to crash itself. Luckily for me, I managed to recover the data folder from my MySQL installation.</p>
  
  <p>The bad part is that not all my tables work as they did before. For example: my users table is useless because it doesn't have any structure anymore but only the rows within it (the .frm and .ibd files). I tried the following query to resolve this problem:</p>
  
  <pre><code>REPAIR TABLE users USE_FRM
  </code></pre>
  
  <p>Sadly, this showed me the error 'Can't open table' and now I still haven't managed to restore this table.</p>
  
  <p>If anyone could help me out with this problem, I'd realy appreciate it!</p>
  
  <p><em>I would be happy to share the ibd and frm files if needed.</em></p>