开发者

Where does WAMP server store database files

开发者 https://www.devze.com 2023-02-20 20:47 出处:网络
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.

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.


I needed to re-install Wamp and I recovered my databases by copying the data directory in wamp\bin\mysql\mysql-version\ from a backup, phpMyAdmin picked up the databases and tables.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号