How to change mysql database directory on WAMP How to change mysql database directory on WAMP windows windows

How to change mysql database directory on WAMP


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


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.


i Have better idea ...open phpmyadmin page ... and select you data base ... on the operations tab and in the Rename database to section ... write your new Database name . you will see tow message . press yes button for both