MySQL data files lost

Recently reinstalled my system. Copied whole MySQL folder from C:/Programdata. Then copied back to the same directory on new system, now the Navicat Premium shows the list of db's but when i'm trying to open one of db tables it shows me

I can't open any ta开发者_高级运维ble. What to do? Ho can I fix it? Please help

I'm afraid that your default DB storage was MyIsam and if you don't exported the databases then you doesn't have any solution to recover your data. The same thing happened to me and I spent lot of time with searching any good solution but I didn't find no one.

There is two solution to avoid these problems on the future: you export the database before the reinstall, or you can set the default DB storage to InnoDB and then the "copy back" solution it is working.

Maybe I was wrong (and I hope I was wrong :) ) I just described my own experience about this topic.