I get the following error when doing a SELECT against my database. This occurs immediately after I import my schema and data (10 tables and 6,000 rows of data).

ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_47ff_5.MYI'; try to repair it

I have tried doing a "REPAIR TABLE <table name>" on all of my tables. I do not understand which table is corrupt or how to prevent the corruption when I do my import.

I'm using myISAM tables.

Version: mysql Ver 14.12 Distrib 5.0.89, for pc-linux-gnu (i686) using readline 5.1