Moving mysl to home directory

[ssgill]

Hello, planning to move mysql to home directory.
Following this KB: https://help.directadmin.com/item.php?id=12

Looks straight forward, just want to clarify the the last step

ProtectHome=true

I didn't found this variable set in configuration, just want to be future proof would like this set it to false.
On researching found the guide how to set this on mariadb site

https://mariadb.com/kb/en/systemd/#configuring-access-to-home-directories

Has anyone tried this, from looks of it will survive updates on mariadb

Thanks for your time.

 

[ssgill]

Quick update, followed instructions from both the links ( just have to change mysql start and stop commands as per your distro) and mysql is working fine been up and running for 4 days now no issues.

Hello, planning to move mysql to home directory.
Following this KB: https://help.directadmin.com/item.php?id=12

Looks straight forward, just want to clarify the the last step

ProtectHome=true

I didn't found this variable set in configuration, just want to be future proof would like this set it to false.
On researching found the guide how to set this on mariadb site

https://mariadb.com/kb/en/systemd/#configuring-access-to-home-directories

Has anyone tried this, from looks of it will survive updates on mariadb

Thanks for your time.

 

[ssgill]

I replied to soon, mysql started crashing again. i know the issue its that data directory is move t home

Can't create test file /var/lib/mysql/matrix.lower-test

Checked file present /etc/systemd/system/mariadb.service.d/dontprotecthome.conf

[Service]

ProtectHome=false

According to mariadb this flag should make it work.

My var doesn't have enough space, i followed this article

Filesystem and quotas | Directadmin Docs

DirectAdmin Knowledge Base

docs.directadmin.com

Thanks