WAMP重新安装后部分数据库内容消失

2022-01-05 00:00:00 wamp mysql wordpress phpmyadmin wampserver

我搞砸了 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 备份我的数据库(有关如何在此场景中进行备份的任何提示都会有所帮助)

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 站点的数据库是空的

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_backupinmysqlmysql(old version) to wampinmysql

再次启动 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.

Wamp 现在应该从新 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.

希望一切顺利,应该的.

I hope this goes smoothly, it should.

相关文章