Re: Corrupted table

2010-03-20 Thread Zakai Kinan
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 wrote: > From: Walter Heck > Subject: Re: Corrupted table > To: "Zakai Kinan" > Cc: mysql@lists.mysql.com > Date:

Re: Corrupted table

2010-03-10 Thread Walter Heck
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 wrote: > Is there a way to know exactly which table is corrupted with such an e

re: "Corrupted" Table (?)

2002-10-02 Thread Egor Egorov
Philip, Tuesday, October 01, 2002, 5:49:47 PM, you wrote: PD> I have a table which was accessible for the last couple years but is now PD> inaccessible after performing a simple alter table command. PD> There are approx. 10 tables in this database on which the same alter table PD> command was

Re: corrUPted tabLE questions...

2001-11-23 Thread Carl Troein
Jim Ray, @WD writes: > > I have a tabel that seems to be corrupted. Is there a way to fix it? It is > running on a Lynx box. Atari Lynx? Does MySQL really run on that? Or did you mean Linux? Hmm... Anyway, look in the manual. REPAIR TABLE is good place to start, as is myisamchk. And make sure