Incorrect key file for table "/var/lib/mysql/.tmp/#sql_d57_2.MYI" ??

Incorrect key file for table "/var/lib/mysql/.tmp/#sql_d57_2.MYI" ??

am 15.07.2010 13:41:47 von Per Jessen

What does this error mean?

mysql> select ipaddr,reverse,count(distinct domain) from mxdata,domain
group by ipaddr;
ERROR 126 (HY000): Incorrect key file for
table '/var/lib/mysql/.tmp/#sql_d57_2.MYI'; try to repair it


/Per Jessen, Zürich


--
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: Incorrect key file for table "/var/lib/mysql/.tmp/#sql_d57_2.MYI" ??

am 15.07.2010 14:10:41 von Per Jessen

Per Jessen wrote:

> What does this error mean?
>=20
> mysql> select ipaddr,reverse,count(distinct domain) from mxdata,domai=
n
> group by ipaddr;
> ERROR 126 (HY000): Incorrect key file for
> table '/var/lib/mysql/.tmp/#sql_d57_2.MYI'; try to repair it

Please ignore.


/Per Jessen, Zürich


--
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