P
P
Pavel K2016-02-27 23:18:22
MySQL
Pavel K, 2016-02-27 23:18:22

Why are there no tables even though they are (mysql)?

Greetings!
Something very strange happened on the server.
There are tables, but there are no tables O_o.
Those. SHOW TABLES;shows,
but select * from tablename says that there is no such table.
mysqlcheck says this:

Error    : Table 'dbname.tablename' doesn't exist
status   : Operation failed

and so with everyone!
What could happen (I suppose fs damage because the server just went down at that moment) and most importantly - how to fix it?
PS there is a data backup, there is no structure backup.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton Natarov, 2016-02-27
@PavelK

Make in the console
Generally such problem was. The database user was given the right to connect, but they forgot to give the right to sql commands. Then such a contraption comes out, maybe it?
If you write in php look inside the engine. MB there are migrations and you can roll them to return the structure.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question