List:General Discussion« Previous MessageNext Message »
From:kabel Date:July 9 2009 6:07pm
Subject:Re: Table problem
View as plain text  
On Thursday 09 July 2009 01:56:37 pm Zakai Kinan wrote:
>   I have been getting this error on a database:  Incorrect key file for
> table '/tmp/#sql_a99_0.MYI'; try to repair it.  How do I know which table
> is causing this error?
> TIA,
> ZK

You could be running out of space on your temp partition.. if a query is 
either creating an explicit temporary table or generating one as part of 
execution, it may be filling it up.

Table problemZakai Kinan9 Jul
  • Re: Table problemkabel9 Jul
    • RE: Table problemMartin Gainty9 Jul
Re: Table problemZakai Kinan9 Jul