Apache Friends Support Forum

Hi,

I was wondering how to change the default mysql datadir. I noticed that the setting was not in /etc/my.cnf. I also noticed that the datadir seems to be set during startup when I issue ./lampp start, because checking my processes shows : .../opt/lampp/bin/mysqld_safe --datadir=/opt/lampp/var/mysql...

Is there a way to change this startup option or is there any file I can edit to change the datadir?

Also, after I change the datadir, can I simply move the files in the current datadir over and mysql should keep working?

Thanks

anyone?

i figured it out, in your lampp dir, in /etc/my.cnf, add a datadir=/path/to/new/datadir/

copy all the current files in /var/mysql into the new datadir

make sure to chown and chgrp -R the new folder to nobody

after that restart lampp and it should work