PDA

Click to See Complete Forum and Search --> : [RESOLVED] Change MySQL Databse Path


navram
Aug 24th, 2007, 03:51 PM
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
Aug 24th, 2007, 10:19 PM
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
Aug 24th, 2007, 10:50 PM
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