The Geek Stuff shows you how to restore MySQL tables when all or some of the tables are lost, or when MySQL fails to load table data

One of the reason for this to happen is when the table data is corrupted.

In this particular scenario, when you connect to the MySQL database server, you cannot see one more tables, as they are missing.

Under this scenario, the MySQL log file contained the following messages:

  How to Recover InnoDB MySQL Table Data from ibdata and .frm Files