MySQL Forums
Forum List  »  Data Recovery

Re: help restoring mysql database after an accident
Posted by: Ryan Marker
Date: January 19, 2010 04:12PM

UPDATE: I was reviewing the Error Logs and found this:

100119 16:09:22 InnoDB error:
Cannot find table toyocolormysql/information 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.
100119 16:09:22 [ERROR] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt.exe: Can't open file: 'information.ibd' (errno: 1)
100119 16:09:24 InnoDB error:
Cannot find table toyocolormysql/information 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.

Does anyone know what that means?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: help restoring mysql database after an accident
3338
January 19, 2010 04:12PM


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.