重新安装WAMP后，一些数据库内容消失了 [英] Some database content disappeared after WAMP reinstallation

问题描述

我搞砸了Apache的配置文件

I screwed up the config files for Apache

我在同一个文件夹中重新安装了WAMP(没有任何卸载)，但是我没有安装2.4，而是安装了2.5，所以WAMP之后失败了.

I reinstalled(without any uninstall) the WAMP in same folder but instead of 2.4 I did 2.5, so WAMP failed gloriously afterward.

我无法再访问WAMP，因此无法从PHPMyAdmin备份数据库(有关如何在此Senario中进行备份的任何提示都会有所帮助)

I can not access WAMP anymore, so I can not backup my DBs from PHPMyAdmin (any hint about how to do backup in this senario will be helpful)

我复制了整个/wamp文件夹的内容(搞砸了安装之后).

I copy the whole /wamp folder content (after screwed up the install).

我安装了2.4版本，现在正在运行WAMP，所有数据库仍在此处列出.但是当我访问两个WP网站时，他们要求我创建一个新的网站标题，但不允许我设置用户名(例如"User(s ) 已经存在.").

I installed the 2.4 version Now WAMP running All DBs are still listed there But when I accesss two of the WP sites, they ask me to create a new site title, but not allow me to set username (says"User(s) already exists.").

现在我回到PHPmyAdmin，发现该WP站点的数据库为EMPTY

Now I went back PHPmyAdmin and found the db for that WP site is EMPTY

我想知道如何才能以某种方式检索存储在原始/wamp文件夹备份中的良好数据库信息，从而转移到新的数据库中，从而使EMPTY的db表再次填充原始数据?

I wonder how can I retrieve the good database information stored in that original /wamp folder backup, somehow, transfer into the new one, so that the db table that is EMPTY will populate with the original data again?

谢谢

推荐答案

最安全的恢复方法可能是:

Probably the safest way to recover is to:

停止WAMPServer.

Stop WAMPServer.

将旧的MySQL文件夹复制到新安装的WAMPServer

Copy the old MySQL folders to the new install of WAMPServer

就是这样

copy \wamp_backup\bin\mysql\mysql(old version) to \wamp\bin\mysql\

再次启动WAMPServer.

Start WAMPServer again.

现在在菜单中

Wampserver -> MySQL -> Version 

您应该看到旧的mysql版本以及新安装的新版本.

you should see you old mysql version and the new one that came with the new install as well.

通过单击该菜单上的旧版本号来切换到旧版本.

Switch to the old version by clicking on the old version number on that menu.

现在沼泽应该从新的MySQL切换到旧的MySQL.等待WAMPServer再次变绿.

Wamp shoud now switch from the new MySQL to the old. Wait for WAMPServer to go green again.

检查Mysql错误日志，看是否发生了不愉快的事情，如果没有发生，

Check the Mysql error log, to see if anything unpleasant has happened, if not,

然后，您可以使用phpmyadmin或用于备份丢失的数据库的任何工具.

You can then use phpmyadmin, or whatever tool you are used to to backup your missing databases.

然后切换回新版本的MySQL，并将数据库还原到该版本的mysql.

Then switch back to the new version of MySQL and restore the databases to this version of mysql.

我希望一切顺利，

这篇关于重新安装WAMP后，一些数据库内容消失了的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！