How to Virtualmin Debian and MySQL tempdir settings?

Howdy :)

I want to change tmpdir '/tmp' to '/mnt/sd/b/mysql-tmpdir'. But if I add line 'tmpdir=/mnt/sd/b/mysql-tmpdir' to '/etc/mysql/mysql.cnf' or 'mariadb.cnf' file than I take unknown variable 'tmpdir=/tmp' error.

Thank you...

Status: 
Active

Comments

Howdy -- you should be able to set the "tmpdir" variable in the /etc/my.cnf file... it would look something like this:

tmpdir = /mnt/sd/b/mysql-tmpdir

It would need to be in the [mysqld] section or you could see errors.

It looks like you're using Virtualmin GPL there, and the area here is for folks using Virtualmin Pro. If you have additional questions, it's no problem to get support, but you'd want to use the Forums for that. We monitor the Forums, along with lots of wonderful folks in the community. Thanks!