Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My laptop's motherboard just died and I am accessing the hard drive from it via a USB adapter on my second computer.

I would like to download the contents of a MySQL 5.1.32 database that is located on the drive, so I can copy it to my other computer.

The MySQL install is part of a WAMP install and I am attempting to access it on an XP desktop.

Can somebody advise me on how to do this? Thanks!

share|improve this question

closed as off topic by Iain Apr 5 '13 at 6:26

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

mysql databases and tables reside in /var/lib/mysql folder

share|improve this answer

You might be able to edit the my.cnf file and change the value of:


To point to the data directory on the usb drive. Then start mysql on the new machine and export the data.

I don't know where my.cnf is on a Windows box. But that is what I would do on Linux.

share|improve this answer

Usually Mysql on Windows is installed in the "Program Files" directory (c:\Program Files\Mysql\Mysql server) and you should copy the entire "data" directory (which is container for all mysql databases in a standard installation).

If you don't find this folder, search the my.ini file (probably in c:\Program Files\Mysql\Mysql server) and read the "datadir" value, it show you where are the database directory.

share|improve this answer

Any easy though not really approved method would be to install the same version of wamp that was on your laptop onto your second computer than then once it's installed just replace the mysql folder entirely.

share|improve this answer
up vote 0 down vote accepted

Unfortunately, none of the provided answers worked for me. I ended up starting over from scratch.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.