List:General Discussion« Previous MessageNext Message »
From:Brian Andrews Date:April 18 1999 5:02am
Subject:RE: Selecting a Drive to avoid "Drive Full" Problem
View as plain text  
> 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

Thread
Selecting a Drive to avoid "Drive Full" Problem(Brandon Shuey)18 Apr
  • RE: Selecting a Drive to avoid "Drive Full" ProblemBrian Andrews18 Apr