JamesSmith

Well-Known Member
Sep 17, 2003
185
0
166
UK, Luton
Hi,

Currently I believe the mysql databases are in the /var partition. This is almost out of space. Would like to move existing and any to be created databases to /usr/mysql or /usr/home/mysql for example.

Has anyone attempted this, or if anyone has some instructions on doing this, would be great.

Server info: WHM 8.4.0 cPanel 8.5.3-S6 FreeBSD 4.8-RELEASE
 

JamesSmith

Well-Known Member
Sep 17, 2003
185
0
166
UK, Luton
hrm.

That looks a bit simple, are you sure that is 100% how it should be done?

Just wondering how cpanel knows its been changed ..

And is mysql stopped before doing any of it?
 

RandyO

Well-Known Member
Jun 17, 2003
173
0
166
Originally posted by JamesSmith
hrm.

That looks a bit simple, are you sure that is 100% how it should be done?

Just wondering how cpanel knows its been changed ..

And is mysql stopped before doing any of it?
Hmm I will see about making it more complicated :D As it is a simple redirect I don't know that mysql needs stopped except to maybe copy the current db's
 
Last edited:

JamesSmith

Well-Known Member
Sep 17, 2003
185
0
166
UK, Luton
For others to know in the future, I e-mailed cPanel support, who suggested:

/usr/local/etc/rc.d/mysql-server.sh stop ; mv /var/db/mysql /usr/home ; ln -s /usr/home/mysql /var/db/mysql ; /usr/local/etc/rc.d/mysql-server.sh start

It worked :)

Thanks goes to Michael Photakis, cPanel Support Staff.