在不替换现有mysql数据库的情况下重新安装Wamp Server [英] Re installing Wamp Server without replacing the existing mysql database

问题描述

我的计算机上安装的WAMP服务器存在一些问题，每次尝试访问浏览器中的服务器文件时，页面都会持续加载数小时，并且不会给我任何错误.

I have some problem with WAMP server installed on my computer, every time I am trying to access a server file in the browser the page keeps on loading for hours and does not give me any errors.

所以我虽然要继续安装新的数据库，但是我现有的MySQL数据库中有很多数据我不想丢失，我尝试使用命令行备份数据库，但那里也没有帮助

So what I though is to go ahead and install and new one but my existing MySQL database has lot of data inside it that I do not want to loose, I tried to backup the database using command line but no help there as well.

有什么办法可以在保持现有MySQL数据库的同时安装新的WAMP服务器?

Is there any way I can install a new WAMP server while keeping my existing MySQL database?

推荐答案

Wamp服务器将所有mysql数据库表存储在WAMP_DIR_LOCATION\bin\mysql\mysql5.5.16\data中的.frm格式中，您需要将此"data"文件夹重命名为"data-old"

The wamp server stores all of mysql database table in .frm formate inside WAMP_DIR_LOCATION\bin\mysql\mysql5.5.16\data you need to rename this "data" folder to "data-old"

重新安装wamp服务器后，只需将"data-old"文件夹重命名为"data"，这样就不会丢失数据库.

And when you have reinstall the wamp server just rename the "data-old" folder to "data" In this way you will not lose your database.

这篇关于在不替换现有mysql数据库的情况下重新安装Wamp Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！