From: Brian Andrews
Date: April 18 1999 5:02am
Subject: RE: Selecting a Drive to avoid "Drive Full" Problem
List-Archive: http://lists.mysql.com/mysql/2006
Message-Id: <000401be8958$b4a1e9f0$487411ce@ihug.co.nz>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

> 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