My centOS 7 server had an unexpected shutdown. For some reason one of the mysql database shows that all tables are empty, but if I browse the files in /var/lib/mysq/database I can see the files(.frm and .ibd and the other files) opening them with a text editor I can read some of the data in it.
What's wrong here? why is one of my database not reading the files or loading the data?
Edit: I still have all my files related to the database such as ibdata1, all other databases/schemas are working fine except for one. That one database I can browse the tables but loading the data shows empty tables.