[RESOLVED] Change MySQL Databse Path

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

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.

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 :D