[RESOLVED] Change MySQL Databse Path

[navram]

sir,
i have installed xampp on my local system and i am working on php and mysql. my question is how can i select a mysql database on a different location otherthan C:\xampp\mysql\data. for example if mysql database is located in d:\mydatafiles folder, how can select the database using phpmyadmin? i don't want to copy my database to C:\xampp\mysql\data

please help

ram

[penagate]

MySQL will only read databases from one location. You need to either change the path to the data files in my.ini, or move the database to the xampp folder.

[navram]

thank u sir....
i changed the path of database in
c:\xampp\mysql\bin\my.cnf
datadir=e:\mydata

thank u once again
i got it
ram