MySQL Forums
Forum List  »  InnoDB

2 Incorrect key file for table 'C:\WINDOWS\TEMP\#sql3a4_ef_2.MYI'; try to repair it SQL1.sql 1 1
Posted by: Asad Raza
Date: September 01, 2010 02:33AM

Hi All,

I am facing strange issue while querying view. When I query the view it says "2 Incorrect key file for table 'C:\WINDOWS\TEMP\#sql3a4_ef_2.MYI'; try to repair it SQL1.sql 1 1 ". The view is using 10 tables which are joined using left outer join. Strange thing is that when I query each base table then there is no issue but when I query view it gives invalid key file error.

Any suggested fix of this problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
2 Incorrect key file for table 'C:\WINDOWS\TEMP\#sql3a4_ef_2.MYI'; try to repair it SQL1.sql 1 1
3555
September 01, 2010 02:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.