在WAMP中还原数据库 [英] Restore Database in WAMP

问题描述

我在WAMP中没有几个与不同项目相关的数据库.我不知道发生了什么，今天，当我去PhpMyAdmin时，我只能看到默认数据库，而其余数据库没有显示，甚至与这些数据库相关的php代码也抛出了数据库未找到的错误.但是，当我转到"D:\ wamp \ bin \ mysql \ mysql5.1.30 \ data"时，带有我的数据库名称的文件夹就在那里.但是不确定如何还原这些数据库，我没有该数据库的任何备份，有人可以帮助我如何还原它们吗?

I had few databases related to different projects in the WAMP. I don't know what happened, Today, when I go to PhpMyAdmin, I was just able to see the default databases and rest of my databases are not showing and even the php code related to those databases are throwing database not found errors. But when I go to "D:\wamp\bin\mysql\mysql5.1.30\data" the folders with my DB names are there. But not sure how to restore those DBs and I don't have any backup of the DB, Can any one help me how to restore them?

推荐答案

您可以将这些文件复制到另一个位置，并在安装后重新安装相同的WAMP版本，将它们复制回原始位置. 请注意，您的WAMP版本应该相同，因为如果版本会更改，那么mysql版本也会更改.

You can copy these file to another location and reinstall the same WAMP version after installtation copy them back to original location. Please note that your WAMP version should be same, because if the version will change then mysql version will also be change.

这篇关于在WAMP中还原数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！