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 <[email protected]> wrote: > From: Walter Heck <[email protected]> > Subject: Re: Corrupted table > To: "Zakai Kinan" <[email protected]> > Cc: [email protected] > 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 <[email protected]> > 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/[email protected] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[email protected] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
