error 100

error 100

I'm seeing this 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.

and in the err log. the error log is a few gigs in size because of this. Any thoughts on how to fix the error?



160106 13:44:53 [ERROR] ../mysql/\bin\mysqld-nt: Can't open file: 'syslog_hr_tre
nd.ibd' (errno: 1)
160106 13:44:53  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:44:53 [ERROR] ../mysql/\bin\mysqld-nt: Can't open file: 'syslog_hr_tre
nd.ibd' (errno: 1)
160106 13:44:53  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:44:53 [ERROR] ../mysql/\bin\mysqld-nt: Can't open file: 'syslog_hr_tre
nd.ibd' (errno: 1)
160106 13:44:53  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:44:53 [ERROR] ../mysql/\bin\mysqld-nt: Can't open file: 'syslog_hr_tre
nd.ibd' (errno: 1)
160106 13:44:53  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:44:53 [ERROR] ../mysql/\bin\mysqld-nt: Can't open file: 'syslog_hr_tre
nd.ibd' (errno: 1)
160106 13:44:53  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.







                New to ADSelfService Plus?