If you recently restored a mysql database from a tar file and found it without any MYI files you will get he following error when trying to run sql against the tables.
ERROR 1017 (HY000): Can’t find file:
You can fix this by running:
REPAIR TABLE TABLENAME USE_FRM;