MySQL Forums
Forum List  »  InnoDB

Tables missed in phpMyAdmin, but present in Explorer?!
Posted by: Guillaume HUCHET
Date: December 01, 2008 11:15AM

Hi.

First of all, sorry I don't speak English very well ... I'm french! ;-)

I already explained my problem in the French Forum but nobody answer me. :(

---------------------


Here it is the error message which appeared in MySQL LOG since the Virtual Machine where my Database is installed crashed (too long to explain here ...):


081127 14:00:31081127 14:00:31 [ERROR] Cannot find table maBaseDeDonnees/maTable 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?

See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html how you can resolve the problem.



I tried to follow advices which are noted in the Web page, but I always couldn't solve my problem!

"SHOW ENGINE INNODB STATUS" display only basic information no warnings.


In phpMyAdmin ...




... even though tables are in Explorer!!!





Please help me.

Thanks in advance.

Gôm

Options: ReplyQuote


Subject
Views
Written By
Posted
Tables missed in phpMyAdmin, but present in Explorer?!
2722
December 01, 2008 11:15AM


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.