问题描述
我的计算机上安装的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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!