Jul 172011
How to change the MySQL temporary directory
Answer:
To change the temporary directory of your MySQL server to use a non-default directory, you can change the tmpdir parameter in your my.cnf
..
tmpdir = /data/tmp
..Don't forget to change the permission of that temporary directory
# sudo chmod mysql:mysql /data/tmp
Then restart MySQL to take effect.
# /sbin/service mysqld restart
