Changing MySQL datadir!

Greets;

I'm running out of space on the partition the MySQL data dir (the db's, that is) is placed on and was wondering if I could move it somehow?

It's probably a simple command to change dirs (or to edit a line in a conf file?) but I didn't find anything about it on the net.

Move it as in moving the existing one plus making sure that MySQL places all new dbs/updates/files in the new location.

Thanks a lot! Quick answer appreciated.

-Felix

 

Nope won't work with symlinks.

I need to change the datadir variable that Cpanel uses when starting/restarting MySQL but I fear it's hidden in the cp code??

I did try adding a datadir= var in the my.cnf files under [mysqld] but it stopped working once I removed the old data dir so I suppose it had no effect.

Would appreciate all and any ideas!

cPanel.net Support Ticket Number: