tmpdir

[Michael Widenius]

>>>>> "JJ" == JJ Hendriksen <jj-mail@stripped> writes:

JJ> Hi all!
JJ> How do I set the tmpdir variable for MySQL? When I use the PHPMySQLAdmin tool,
JJ> I can see the system variables  MySQL has got, and I see an empty tmpdir (which
JJ> may be causing some query troubles I am having). I tried to enter
JJ> set-variable tmpdir=c:\temp 
JJ> in the my.cnf on C:\
JJ> didn't work, mysql wouldn't start as a service anymore after i tried this..:(

JJ> Can anybody help me out here?

Hi!

just use:

[mysqld]
tmpdir=c:/temp


Regards,
Monty

PS: Sorry for the long delay before replying, but I just come back from
    a 2 weeks vacation trip.