I was using Xampp out of the box and was doing some development work. Someone deleted my Xampp directory but full mysql data folder with ibdata1, iblog, db folders is present. Db folders only have ibd file and no frm file. I installed a new version and pasted whole data folder and upon mysql startup I can see the database but there are no tables in it . I also confirmed that InnoDb is actually referring to ibd files of these tables by changing the db folder name and checking the logs. How can I see the tables? i have searched everywhere and every method suggests using frm files which I don't have.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.