Incorrect key file for table; try to repair it.

sheru2302 · #1 (**permalink**) 01-09-12, 01:38

Hi everyone.
I'm currently continuing my colleague's project, where in it there is a report which is having error as follows.

"Failed to open a rowset. Details: HY000:[MySQL][ODBC 5.1 Driver][mysqld-5.1.52] Incorrect key file for table '/tmp/#sql_2874.MYI'; try to repair it."

I am using a ODBC connecter to connect to the MySQL Server. How or where I can correct the issue. I couldn't find out the course of the error.

Thank you in advance.

r937 · #2 (**permalink**) 01-09-12, 03:47

did you try the REPAIR command?

chandu123 · #3 (**permalink**) 01-09-12, 04:29

it might be due to insufficient space in tmp file

Internet Services

Web Development

Digital Marketing

Consumer Tech