Corrupted table

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=gcdmg-mysql-2@m.gmane.org

Re: Corrupted table

That message usually means you ran out of space in your temp folder locatio=
n.

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 erro=
r:  [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=3Dlists@o=
lindata.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Corrupted table

I switched the tmp directory to a much bigger partition and I am still gett=
ing the error. Any other ideas? TIA, Zak --- On Wed, 3/10/1=
0, Walter Heck wrote: > From: Walter Heck er@openquery.com>=0A> Subject: Re: Corrupted table=0A> To: "Zakai Kinan" itanyen2000@yahoo.com>=0A> Cc: mysql@lists.mysql.com=0A> Date: Wednesday, M=
arch 10, 2010, 8:29 AM=0A> That message usually means you ran=0A> out of sp=
ace in your temp folder location.=0A> =0A> cheers,=0A> =0A> Walter Heck=0A>=
=0A> --=0A> Engineer @ Open Query=0A> http://openquery.com | http://openqu=
ery.com/blog=0A> =0A> On Thu, Mar 11, 2010 at 02:16, Zakai Kinan 000@yahoo.com>=0A> wrote:=0A> > Is there a way to know exactly which table =
is=0A> corrupted with such an error: =A0[ERROR]=0A> /usr/local/mysql/bin/my=
sqld: Incorrect key file for table=0A> '/tmp/#sql_7885_0.MYI'; try to repai=
r it.=0A> >=0A> > TIA,=0A> >=0A> >=0A> > ZK=0A> >=0A> >=0A> >=0A> >=0A> > -=
-=0A> > MySQL General Mailing List=0A> > For list archives: http://lists.my=
sql.com/mysql=0A> > To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?uns=
ub=3Dlists@olindata.com=0A> >=0A> >=0A> =0A> --=0A> MySQL General Mailing L=
ist=0A> For list archives: http://lists.mysql.com/mysql=0A> To unsubscribe:=
=A0 =A0 http://lists.mysql.com/mysql?unsub=3Dtitanyen2000@yahoo.com= 0A> =0A=
> =0A

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg