I've got a problem with a database here, in which after one update on the database one table stopped working. What i can't do (Considering table xxx): Dump whole database; (it says that the table doesn't exist)
SELECT *
FROM xxx; (it says that the table doesn't exist)
CREATE TABLE xxx(id int); (it says that the table exists)
I can't find any solution on the internet.
The Table Appears when you do a show tables?
Have you tried restart the mysql service?