In my.cnf its called tmpdir change that location tmpdir=<where you want tmp to be>
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: dan orlic [mailto:[EMAIL PROTECTED] -->Sent: Friday, October 03, 2003 11:20 AM -->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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
