This question already has an answer here:

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.

marked as duplicate by Max Vernon, Marco, Julien Vavasseur, Colin 't Hart, Tom V Jan 10 '17 at 14:17

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.

  • dba.stackexchange.com/questions/57120/… - that answer from Rolando is fairly succinct. The tool to gather the DDL is mysqlfrm. – dwjv Aug 5 '16 at 13:17
  • Great. Thank you dwjv. I really needed that answer to know what tool to use. – David Borrink Aug 6 '16 at 15:12
  • Two thoughts I have, though, now that I review it... 1) the instruction to "Run the SQL to create the InnoDB table". I learned that a new installation of MySQL creates a fresh ibdata1 file which apparently is generic. I can move a copy of my 5.6.17 ibdata1 file into the 5.6.12 folder to do that. 2) what is the command that I would use in mysqlfrm to get to the database to start this. Do I put my path in the command line? Would that establish the connection to start the commands. It's like I'm right at the door step to do this. I just don't know to "knock" on the door and get in. – David Borrink Aug 6 '16 at 16:24
  • Now attempting to get in, but unable to get mysqlfrm.exe to stay open, or get Windows commands to start. Question is at this post: dba.stackexchange.com/questions/146083/… – David Borrink Aug 6 '16 at 20:32
  • It sounds like you might be just double-clicking the executable. You need to run command (cmd) and execute from there. By "Run the SQL to create the InnoDB table" they mean to execute the SQL generated from the .frm file. – dwjv Aug 8 '16 at 8:39

Browse other questions tagged or ask your own question.