-----Original Message-----
From: dan orlic [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 1:20 PM
To: '[EMAIL PROTECTED]'
Subject: changing TMPDIR for tempory file location
Hello all,
My query is about changing the tmpdir on mysql. As stated in on the
mysql.com site it states that if it is not set it uses the default, in
my case, the default was /tmp. It also states that to change it you can
do so in the mysqld_safe startup file. It makes no mention of changing
it in the my.cnf file.
My questions are:
1) Can you set the tmpdir in the conf file my.cnf? if so, how?
2) if you can only make that change in mysqld_safe, how do you?
I did not mention the change at command line, e.g. mysqld_safe
-tmpdir=/whatever because I don't want to have to change the startup
scripts.
Thanks for the help,
dan
