juggernautsei wrote on Saturday, July 30, 2011:
Hi,
I am posting here because I have searched all the forums and there is nothing like this post in any of the forums and I feel I will get the most help here. The below message is what I am getting in the windows event log.
Cannot find or open table garris/notification_log from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn’t support.
See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
how you can resolve the problem.
I have run SHOW ENGINE INNODB STATUS against the database and there are not errors
Any MySQL gurus on board?
Thanks in advance!
Sherwin