Unanswered: Incorrect information in file './testdb/testemp.frm'
While try to execute a select query on a InnoDB table i am getting "ERROR 1033 (HY000): Incorrect information in file: " Error. But on the same DB i can excecute select query on tables having MyIASM as Engine.
My MySQL server version is 5.0.22 running on Linux OS.
have_innodb variable value is showing as DISABLED
i have checked /etc/my.cnf file. Following is the content.
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
Any one suggest me ......... How to correct the above error