I have a mysql installed inside a windows virtual machine. The hard drive was crashed and the system is not able to restore all again. But I can have access to entire c: ROOT. So I went to
c:/ProgramData/Mysql/Mysql Server 5.5/data/myDatabaseName
There I can see different files like: .frm, .opt, .trg and .trn. In a regular way, I could run a mysqldump to backup and restore all database from command line, but the system is not able to be restored. So I had to copy all these files and past inside inside the same directory inside same database in another physical instance.
The issue is some tables are not been recognized by this new instance. So I think copy and past is not enough to restore the database.
What am I missing?
Note: Database has innoDb and Myisam tables.