InnoDB tables visible, but MySQL reports they don't exist.
This problem is causing a pickle for me. I have tried to restore a database by dropping it into the data folder. Big mistake. Anyway, this DB has 3 tables, one myISAM, 2 innoDB. The 2 innoDB tables are visible in WorkBench and other managers, but MySql won't drop them or allow any operations on them, reporting that the tables Do NOt Exist. Then, trying to ADD the tables results in an error that the tables ALREADY EXIST. Well, there must be a way to repair these. I can delete the 2 innoDB tables using the filesystem, but I'd like to get the data in them.
Bob
Edited 1 time(s). Last edit at 08/20/2011 03:15AM by Robert Dickow.
Subject
Views
Written By
Posted
InnoDB tables visible, but MySQL reports they don't exist.
5991
August 20, 2011 03:00AM
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.