This question already has an answer here:

please help ...

I want to restore MYSQL database using .frm and .ibd files (that's all I am having). here is additional information..

I reinstalled same version of WAMP without taking backup of mysql data. Now i am remain with "BIN" directory which contains some .frm and .ibd files. When i opend phpmyadmin i can find My old database and table names in browser but when I click on it it says "'xyz'table doesn't exist". But exceptionally one of table is working and displaying it's data. all my tables were of innoDB.

marked as duplicate by mustaccio, Max Vernon, Marco, James Anderson, Julien Vavasseur Jan 9 '17 at 16:25

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Get all .ibd and .frm files into a zip or tar.gz and upload it on https://recovery.twindb.com/ it will recover tables from .ibd files.

tar zcf database.tar.gz /path/to/dir_with_ibd_and_frm

Not the answer you're looking for? Browse other questions tagged or ask your own question.