Where does WAMP server store database files

windows windows-xp database wamp mysqldump
irishbuzz picture irishbuzz · Mar 31, 2011 · Viewed 82.6k times · Source

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-

Answer

Jon picture Jon · Apr 1, 2011

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.

Related questions

How do I free my port 80 on localhost Windows?

I installed XAMPP 1.6.8 and for some reason it didn't work. Later realized port 80 is not free or not listening. How can I release it or make it free? Thanks a lot!

Read More
What's the fastest way to delete a large folder in Windows?

I want to delete a folder that contains thousands of files and folders. If I use Windows Explorer to delete the folder it can take 10-15 minutes (not always, but often). Is there a faster way in Windows to delete …

Read More
Windows could not start the Apache2 on Local Computer - problem

During the installation of Apache2 I got the following message into cmd window: Installing the Apache2.2 service The Apache2.2 service is successfully installed. Testing httpd.conf.... Errors reported here must be corrected before the service can be started. httpd.exe: …

Read More