I switched the tmp directory to a much bigger partition and I am still getting the error. Any other ideas?
TIA, Zak --- On Wed, 3/10/10, Walter Heck <wal...@openquery.com> wrote: > From: Walter Heck <wal...@openquery.com> > Subject: Re: Corrupted table > To: "Zakai Kinan" <titanyen2...@yahoo.com> > Cc: mysql@lists.mysql.com > Date: Wednesday, March 10, 2010, 8:29 AM > That message usually means you ran > out of space in your temp folder location. > > cheers, > > Walter Heck > > -- > Engineer @ Open Query > http://openquery.com | http://openquery.com/blog > > On Thu, Mar 11, 2010 at 02:16, Zakai Kinan <titanyen2...@yahoo.com> > wrote: > > Is there a way to know exactly which table is > corrupted with such an error: [ERROR] > /usr/local/mysql/bin/mysqld: Incorrect key file for table > '/tmp/#sql_7885_0.MYI'; try to repair it. > > > > TIA, > > > > > > ZK > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=titanyen2...@yahoo.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org