0
I just had a strange experience with mysql, I have a database with 8 tables on my local server. Suddenly my system no longer wanted to log in, I went to check on phpmyadmin and showed the tables, but when I gave select received the message:
Table 'sistema.cliente' doesn't exist
I lost my bank? because I didn’t backup the content. NOTE: Not a production server.
You’ve already given one
SHOW TABLES?– Maniero
No way to know. If you have not manually deleted or given a command of type
DROP TABLEshould not have lost, but the certainty depends on you refresh the page and list the tables. Maybe you are just looking at the wrong database or the table name is incorrect, but several commands may delete your table, for example to import a "new" one over.– Fernando Cordeiro
Yes, I used a SHOW TABLES and returned 0. I went to give a drop database and received an error "Error dropping database Errno: 66"
– Pedro Soares
Are you not using the wrong database?
– Maniero
check DB to see if there are no errors. Mysql comes with tools for this.
– Bacco
I already did, the bank appears in phpmyadmin, I can access it but it shows in the left menu the tables in the right does not appear, and if I select the table in the left menu says it does not exist.
– Pedro Soares