This question already has an answer here:
- restore table from .frm and .ibd file? 7 answers
I've put this question out a couple ways on these boards. The last time, I didn't get a response. I've pieced together enough info to try and figure out how to do this, but there is some confusion I have.
I don't have the finances to afford to buy a restoration service at this time, so I'm trying to do it myself. I've tried to contact people here via Twitter since that seems to be the only way to get in touch to answer questions, but I've had no response. My wife would really like to get her data back and is hoping someone can help us restore this set of files on her PC with WAMP.
I've never attempted something like this before. We had a WAMP installation with WordPress running on my wife's PC, and the Aestan tray menu failed. I figured we need to uninstall and re-install WAMP, which left the data files in .ibd and .frm files along with the core WordPress installation. I'm trying to bring them back to life again to be used. The WAMP people recommended I find a way to restore the database files.
I read a post here (Recover MySQL database from data folder without ibdata1 from ibd files) regarding someone who had the same set of "leftover" files and no ibdata file, and was given some advice regarding how to restore using some MySQL utilties. They said, "you can download a MySQL utility that can generate the SQL needed to create the table." I went to Oracle and downloaded the Windows version of their utilities, but there are around 24 .exe files in there! I have no idea which one to use. I was expecting a single app in there, not a collection.
I'm not afraid to try this, but it's not clear which utility(ies) I should use. I'm trusting that the instructions could make sense once I'm actually attempting it. I've been in PHPAdmin a few times so I do know how to make some edits, but doing a restore like this with .ibd and .frm files is new territory for me.
Details: My WAMP installation was using MySQL 5.6.12, and the new WAMP installation uses 5.6.17. The WAMP people said if I restore the database in the 5.6.12 then I'll be able to choose the 5.6.12 setup from the Aestan tray menu. I have made backup copies of the 5.6.12 database files. So I'm ready to attempt this, but would appreciate a little advice from any of you.
I was informed that the ibdata1 file from the 5.6.17 installation could be used in the 5.6.12 as part of the recovery. No database has been set up in the 5.6.17 installation. So I have a "generic" ibdata1 file, I assume.
As you can see, I've really been trying to get this to work. I've spent a lot of time with this, regretting that we never set a Mozy backup of our installation to begin with. How we overlooked that, we don't know, but we know the data is all there, we just need to put these steps in place and restore it. It's seven years worth of old blog posts that we want to recycle back into her site.
Thank you for any advice you can give us.