How to change mysql database directory on WAMP

Question

I'm running a dual boot server with Windows 7 and Ubuntu. On Ubuntu, everything is configured how I want it. On Windows, I need to know how to change my MySQL database directory so that it uses the same directory I'm using on Ubuntu. How do I do this?

Solution 1

Hope this image would guide clear. You can write click and select view image to see my answer clearly

Please don't forget to restart wamp/xampp after these steps then it will be applied

Solution 2

1 in WAMP sever 2.2 [ in windows ],

go to C:\wamp\bin\mysql\mysql5.5.24\my.ini

[2] you will find like this,

datadir=c:/wamp/bin/mysql/mysql5.5.24/data

[3] change this with

" datadir = Your Ubuntu MySql Data Directory Path ".

[4] Then restart wamp serever.

i hope this will helpful to solve your problem.

Thanks.