Cannot drop or create table

55 Views Asked by At

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.

1

There are 1 best solutions below

0
On

The Table Appears when you do a show tables?

mysql> show tables

Have you tried restart the mysql service?