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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org