title: Restoring MySQL databases from file system back up
body: <p>I've had a hard drive crash on me and unfortunately I do not have .sql dumps available to restore my databases. Though I do have a very recent back up of my entire file system.</p>
  
  <p>I've grabbed the files from <code>/usr/local/var/mysql/</code> from my back up and placed it in my fresh reinstall at the same location.</p>
  
  <p>I can see all my databases when I use <code>show databases;</code> via the command line. I can also select a database using <code>use &lt;database&gt;;</code>. However, when I try to access any table on the database I see: <code>ERROR 1146 (42S02): Table 'database.table' doesn't exist</code>. </p>
  
  <p>Thankfully it's only happening for a few less important databases but ideally I'd like to restore them fully.</p>
  
  <p>Thanks</p>