WAMP服务器存储数据库文件的位置 [英] Where does WAMP server store database files

问题描述

我的硬盘驱动器遇到一些问题，我无法使用它启动Windows。

我可以通过连接到另一台电脑来查看驱动器的内容作为一个外部驱动器。

在罪魁祸首的驱动器上，我运行一个本地WAMP服务器为开发目的，我想保存的mySQL数据库。 >

我可以看到我的wamp目录在 E：\wamp 。是否可以从这里启动服务器，以便使用phpmyadmin执行mysqldump？如果没有我的选项来恢复DB -

解决方案

在我的系统上，他们在 C ：\Program Files（x86）\WampServer\bin\mysql\mysql5.1.53\data 。所以在你的，他们会在 E：\wamp\bin\mysql\mysql- version\data 。

您可以从 E：\wamp\bin\mysql\mysql-version\bin 开始 mysql / code>，其中所有的可执行文件。请注意，您要使用的配置文件是 E：\wamp\bin\mysql\mysql-version\my.ini 。

您也可以简单地将所有子目录复制到另一个服务器。我没有MySql专家，但应该让其他服务器使用您的数据库没有问题。

My hard-drive has encountered some problems and I am unable to boot Windows with it.

I am able to view the drive's contents by connecting it to another PC as an external drive.

On the culprit drive I was running a local WAMP server for dev purposes and I'm looking to save the mySQL databases from it.

I can see my wamp directory at E:\wamp. Is it possible to start up the server from here so as to use phpmyadmin to perform a mysqldump? If not what are my options to recover the DB-

解决方案

On my system, they are in C:\Program Files (x86)\WampServer\bin\mysql\mysql5.1.53\data. So in yours they would be in E:\wamp\bin\mysql\mysql-version\data.

You can start mysql locally from E:\wamp\bin\mysql\mysql-version\bin, where all the executables are. Be aware that the configuration file you want to use is E:\wamp\bin\mysql\mysql-version\my.ini.

You can also simply copy all the subdirectories to another server. I'm no MySql expert, but that should let the other server use your databases without problem.

这篇关于WAMP服务器存储数据库文件的位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！