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
dBforums
>
which table needs to be repaired?
03-10-10, 19:28
Linear Mode
