Changing the tmp folder of mysql

You should edit your /etc/my.cnf
tmpdir = /whatewer/you/want

and after that restart mysql

service mysql restart


P.S. Don't forget give write permissions to /whatewer/you/want for mysql user

You can set this permission with:
chown mysql:mysql /newdir

chown mysql:mysql /newdir/mysql


And make sure its writable.
  • mysql, temporary, directory, temp dir
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Disabling Eximstats on cPanel

Eximstats, which comes pre-installed on cPanel does exactly as its name suggests. Stores...

Como solucionar: prefork: server reached –max-clients setting, consider raising it

En caso de recibir el siguiente error: prefork: server reached –max-clients setting, consider...

451 Temporary local problem - please try later

If a domain is in /etc/remotedomains it will be removed from /etc/localdomains.Also, if you have...