Re: Table problem

[kabel]

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.

kabel