americanknight
americanknight

Reputation: 759

How to change mysql database directory on WAMP

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?

Upvotes: 7

Views: 19514

Answers (3)

Sami
Sami

Reputation: 8419

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

Upvotes: 23

pooya laryan
pooya laryan

Reputation: 75

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

Upvotes: -2

VISHAL VIRADIA
VISHAL VIRADIA

Reputation: 1418

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.

Upvotes: 7

Related Questions