Question How do I move the "/var/lib/mysql" and "/var/qmail/mailnames" directories to a different volume under /mnt/drivename/... ?

[Tim den Dikken]

Hi Pleskians,

I'm hosting on a DO droplet which I configured with a extra drive mounted via the /mnt/ folder in Plesk. As I want to give all the subscriptions some extra disk, e-mail and database space. I already moved the vhosts folder with the "transvhosts.pl" utility. This works great now, this leaves me with the "/var/lib/mysql" and "/var/qmail/mailnames" folder yet to be moved.

I've looked all over the form and there has been some threads here and there, but none of them seem to have a complete solution. I assume it is not as simple as just moving the directories as for the vhosts it changed all the config files.

I really hope someone could help me out here!

 

[MarkM]

For MySQL, data directory is specified in my.cnf. Example being;

datadir=/your/new/path/mysql

I'm not sure if anything will break Plesk wise to be honest, so to minimize any possible risk - you may want to symlink after. (do it off peak hours, have a rollback plan, etc.)

For mail, there's an article on that;

https://support.plesk.com/hc/en-us/articles/12377869111319--How-to-change-default-location-of-mailboxes-in-Plesk-for-Linux

 

[MiZi]

You can use bind command and add line to /etc/fstab

/mnt/disc/qmail /var/qmail/mailnames none defaults,bind 0 0
/mnt/disc/mysql /var/mysql none defaults,bind 0 0

Don't forget to set the correct permissions and owner.

 

[MiZi]

of course - a little mistake in 2nd line: (mysql datadir is default /var/lib/mysql)

/mnt/disc/mysql /var/lib/mysql none defaults,bind 0 0