How-To move the mysql tmpdir out /tmp and into /home

Eric Delorme

Question

How do you move the mysql tmpdir out of /tmp and into /home?

MariaDB

Log in to the server via SSH as 'root'
Create the file /etc/systemd/system/mariadb.service.d/override.conf with your preferred text editor, with the following contents:
CONFIG_TEXT: [Service]
ProtectHome=false
Run the following command:
# systemctl daemon-reload
Restart the service:
# /scripts/restartsrv_mysql
Create the /home mysql tmpdir:
# mkdir -v /home/mysqltmp; chown -v mysql:mysql /home/mysqltmp
Put the following in /etc/my.cnf under the [mysqld] section:
CONFIG_TEXT: tmpdir=/home/mysqltmp
Restart MariaDB:
# /scripts/restartsrv_mysql

MySQL

Create the /home mysql tmpdir:
# mkdir -v /home/mysqltmp; chown -v mysql:mysql /home/mysqltmp
Put the following in /etc/my.cnf under the [mysqld] section:
CONFIG_TEXT: tmpdir=/home/mysqltmp
Restart MySQL:
# /scripts/restartsrv_mysql

You can verify that the mysql tmpdir was changed by running the following command:

# mysqladmin variables|grep tmpdir