My MySQL server is hosted by brinkster.com and butlooking in my tables in the QB, I found "Could not fetch columns" under all of my tables except for my MyISAM tables. When I use the MySQL command line utility and "show tables", I see my tables, but when I try to select, "SELECT * FROM My_Table", I get "ERROR 1146 (42S02): Table 'MyDatabase.My_Table' doesn't exist". I should restore my database from a backup. They have no explanation as to what happened.
Using MySQL Administrator, I tried restoring a table I had saved and got an error, "The MySQL Server returned this Error:
MySQL Error Nr.1051-Unknown table 'my_table'". how to proceed?
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --