> I have the shareware version of Mysql running under NT4.0. I
> also have it installed on my E:\ drive. However, when doing large
> queries with joins I get a couple of files in my C:\TEMP\MY10 and
> C:\TEMP\MY12 that are 100+megs and 250+megs. This frequently
> hangs the SQL becuase there isn't enough space on that drive.
>
> My C:\ is much smaller than my E:\ drive. Is there some way to
> have it write those temp files to a directory of my choosing on my
> E:\ drive?
In your my.cnf file add the line:
tmpdir = e:/temp
into the [mysqld] section.
cheers
Brian
+---------------------- I n f o r M a t e ------------------------+
| Brian Andrews Web Design, Web Hosting +64 9 479-7876 |
| Director Software Development +64 21 OFFICE |
| brian@stripped PO Box 33-863 Takapuna |
| http://www.InforMate.co.nz/ Auckland, New Zealand |
+-----------------------------------------------------------------+
Where am I? Here:
http://www.expediamaps.com/default.asp?C=-36.7343250087852,174.748856169468&
A=150&OX=0&OY=0&E=P9a462c
