title: I copied MySQL .MYD, .MYI and .frm files to another server and now phpMyAdmin tries to search a non-existent table
body: <p>OK, so I had a website project I was running locally on my computer using MAMP. Long story short, the computer is out for repairs and I need to figure out how to move the project from my backup disk to an online webserver ASAP. That's easily done for the HTML, PHP, CSS and JS files, but moving over the MySQL data files is more of a puzzle for me. I was able to find the .MYD, .MYI and .frm files, and when I copied them to the server (I created a new database before copying over the files) it seemed to work at first. I see all the tables and data in phpMyAdmin. Then I ran into this oddity: whenever I do a global database search in PMA, PMA attempts to search a non-existent table, causing MySQL to bark.</p>
  
  <pre><code>SHOW FULL FIELDS FROM  `wp_ai1ec_logging` FROM  `foobar` ;
  #1146 - Table 'foobar.wp_ai1ec_logging' doesn't exist 
  </code></pre>
  
  <p>I tried searching the information_schema to see if something was out of sync:</p>
  
  <pre><code>SELECT * FROM  `information_schema`.`TABLES`
  WHERE  `TABLE_NAME` LIKE  'wp_ai1ec_logging'
  </code></pre>
  
  <p>but I came up with nothing. So I went back to the data files and found this curious fact: there was a wp_ai1ec_logging.frm file, but no corresponding wp_ai1ec_logging.MYD or wp_ai1ec_logging.MYI files. What could this mean? I don't know what these file types mean, but it seems like every table has a .frm, .MYD and .MYI file EXCEPT this table for some reason. I had these files backed up to my Time Capsule using Time Machine (I had to connect it to another Mac to restore the files), so my guess is either the last backup went wrong or (more likely) I made some mistake in restoring the files. I've never had to restore Time Capsule files to another Mac and I found it to be WAY more tricky than restoring files to my own computer, so I'm allowing for the possibility that I did it wrong somehow. But assuming the backup was correct and I restored correctly, what else could explain this?</p>
  
  <p>And in case you need to know, this project uses WordPress with Timely's All in One Event Calendar plugin (<a href="http://time.ly/" rel="nofollow">http://time.ly/</a>), so that's what "ai1ec" means. I'm not sure if this table is critical to the current version of the plugin or I should just remove that .frm file and forget about it.</p>