从.frm，ibdata和ib_logfile恢复MySQl数据库 [英] Recovering MySQl database from .frm, ibdata and ib_logfile

问题描述

我的MySQl以前的版本中有.frm，ibdata和ib_logfile，现在我转移到了较新的版本.不幸的是，我没有安装以前的版本，因此无法将转储导入新的MySQl版本.

I have .frm, ibdata and ib_logfile from my previous version of MySQl and now I have shifting to a newer version. Unfortunately, I donot have the previous version installed so I cannot take the dump and import into the new MySQl version.

请提出一些使这些数据库在较新的MySQL版本中运行的方法.我具有上一个MSQl的所有必需文件.

Please suggest some way to get these databases running in the newer MySQL version. I have all the required files from the previous MSQl.

推荐答案

好吧，这似乎微不足道.但是由于我已经保存了先前安装中Program Files中存在的整个MySQL文件夹.我发现我仍然可以使用该文件夹来运行以前的MySQL安装，而无需进行任何更改或重新安装(MySQl的工作方式类似于Linux软件).现在，我使用mysqldump创建转储，然后将其导入到新的MySQL版本中.

Well, it may seem trivial. But since I had saved the entire MySQL folder present in Program Files from my previous installation. I found out that I could still use that folder to run the previous MySQL installation without any changes or reinstallation (it seems MySQl works like Linux softwares). And now I am using mysqldump to create the dump and then will import it into the new MySQL version.

这篇关于从.frm，ibdata和ib_logfile恢复MySQl数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！