Error 100 in eventlog analyzer
Hi I'm getting this error in the windows logs.
../mysql/\bin\mysqld-nt: Can't open file: 'syslog_hr_trend.ibd' (errno: 1)
For more information, see Help and Support Center at http://www.mysql.com.
in the error log in the MySQL data directory I see the following error. How can I resolve this?
160106 13:41:07 [ERROR] ../mysql/\bin\mysqld-nt: Can't open file: 'syslog_hr_tre
nd.ibd' (errno: 1)
160106 13:41:07 InnoDB error:
Cannot find table eventlog/syslog_hr_trend 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?
Look from section 15.1 of http://www.innodb.com/ibman.html
how you can resolve the problem.
160106 13:41:07 [ERROR] ../mysql/\bin\mysqld-nt: Can't open file: 'syslog_hr_tre
nd.ibd' (errno: 1)
160106 13:41:07 InnoDB error:
Cannot find table eventlog/syslog_hr_trend 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?
Look from section 15.1 of http://www.innodb.com/ibman.html
how you can resolve the problem.
160106 13:41:07 [ERROR] ../mysql/\bin\mysqld-nt: Can't open file: 'syslog_hr_tre
nd.ibd' (errno: 1)
160106 13:41:07 InnoDB error:
Cannot find table eventlog/syslog_hr_trend 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?
Look from section 15.1 of http://www.innodb.com/ibman.html
how you can resolve the problem.
160106 13:41:07 [ERROR] ../mysql/\bin\mysqld-nt: Can't open file: 'syslog_hr_tre
nd.ibd' (errno: 1)
160106 13:41:07 InnoDB error:
Cannot find table eventlog/syslog_hr_trend 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?
Look from section 15.1 of http://www.innodb.com/ibman.html
how you can resolve the problem.
160106 13:41:07 [ERROR] ../mysql/\bin\mysqld-nt: Can't open file: 'syslog_hr_tre
nd.ibd' (errno: 1)