New database -- 'can't fetch' innodb tables

[GKChesterton]

I am new to MySQL. After migrating my tables in from Access, I cleaned them up and had them working well in innoDB. But now I can't open them through MySQL Administrator. I can view the table names (in red); I can create a new innoDB table (and behold it can be found as a .frm with the others); but when I try to view existing tables I get the error,

MySQL Administrator Exception:
Cannot fetch table information.

I have fiddled with the my.ini, server variables etc., user permissions ...

Any ideas? I'd rather not have to reimport ... hmm ... a back-up might have made sense here ...

[purple]If we knew what it was we were doing, it would not be called
research [blue]database[white].[/white]development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[GKChesterton]

Woops ... Background information:
My OS is Windows XP Pro.
MySql 5.0
running on localhost

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[Kozusnik]

Try going in directly from the command line...

mysql -u root -p
>root password
>show databases;
>use database_name;
>show tables;
>describe table_name;

That will show the layout if everything is working correctly. If that doesn't work, then post back any error you get.

Mark

 

[GKChesterton]

If I enter as presented, after the first semi-colon and [Enter] I get:
ERROR 1064 <42000>: You have an error in your SQL ... [check] for the right syntax to use near 'mysql -u root -p
root password (I tried both my passwd and literal string 'password' here)
show databases' at line 1

I also tried it all without semi-colons but commands didn't seem to get a response. I never saw anything indicating successful recognition.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[Kozusnik]

If you haven't set a root password for mysql, just hit enter when it asks for the password. Remember the root pw for the database is separate from the OS.

Mark

 

[GKChesterton]

I have set a root password; it happens to be 'root', conceivably that's a bad choice and making a problem but I don't think so.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[GKChesterton]

Follow-up -- I ended up reinstalling MySQL. I hate to say, I haven't made it around yet to seeing if the set of tables in question are now available. Distracted with a different migration project.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​