Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Posts
    1

    Unanswered: Incorrect key file for table; try to repair it.

    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.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    did you try the REPAIR command?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2011
    Posts
    17

    Incorrect key file for table; try to repair it.

    it might be due to insufficient space in tmp file

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •