I recently encountered this problem. My website is down because it can't locate database tables(DB Error: Table table1 does not exist). Under cpanel/phpmyadmin,I tried the mysql> show tables, it shows the tables list that my website used. But on the main interface of phpmyadmin these tables does not appear(left side). Now using data dictionary in phpmyadmin, it display table names that my website used,but does not show data fields of that table.
Additional info, I am not the one who create these missing tables. There are still tables that appear on the database, but these tables are the one that I created. But previously I can see these tables that I did not create at phpmyadmin. I tried SELECT * FROM `missingtable` , and it says table does not exist. These tables are innodb tables. Myisam tables are not affected.
Can anybody clarify this issue? And what should I do. Thanks.