I have a very strange issue wth mySQL.
Yesterday a Db from a server was disappear.
if I log on to phpmyadmin panel i see the DB on the left side menu of phpmyadmin panel but if try to open it (click on it) i got the error "No database slected".
If i run
show DATABASES; i see it on the results, but i can't do any operation with that name.
I tried to run (from command line from the server)
mysqlcheck -u root -p -A
(that would check all databases), but the first message i recieve is
mysqlcheck: Got error: 1049: Unknown database '<db_name>' when selecting the database
And the procedure stop itself without continuing with other DB.
The problem is that i can't restore or recreate it, because the name seems to be in tables schema of mysql.
Any suggestion on what's happen and how to solve it? I simply want to clean my situation and remove the "corrupted" DB from the databases list