ERROR 1017 (HY000):

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;