title: MySQL, copying tables files gives rise to "ERROR 1017 (HY000): Can't find file:" even though its there there
body: <p>I want to copy the database tables from my production server to a local test machine so I can perform test om (copies of) the real data. </p>
  
  <p>I stopped mysql and deleted all the frm, MYD and MYI files. Starting mysql here and querying show tables gives an empty result set. I then shut down mysql and copied all the frm, MYD and MYI files from the server. When starting mysql "show tables" shows the tables as expected but trying to query them I get the error message </p>
  
  <blockquote>
    <p>ERROR 1017 (HY000): Can't find file: './WhateverTableIQuery.frm'
    (errno: 13)</p>
  </blockquote>
  
  <p>But the WhateverTableIQuery.frm file is on the disc and is identical to the one on the server. </p>
  
  <p>Any ideas about what might be the problem?</p>