Re: Specifying a different tmp location

2001-11-26 Thread Martyn Wendon
for temporary files instead of the default /tmp directory Regards, Martyn - Original Message - From: "Delfim Machado" <[EMAIL PROTECTED]> To: "Martyn Wendon" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, November 26, 2001 10:57 AM Subject

Re: Specifying a different tmp location

2001-11-26 Thread Delfim Machado
i don't know if this works, but here it goes export TMPDIR=/what/dir/you/want/mysql/to/use && /etc/init.d/mysql start something like that or edit the init script see http://www.mysql.com/doc/E/n/Environment_variables.html On Mon, 2001-11-26 at 12:06, Martyn Wendon wrote: > Hi, > > Using MySQ

Specifying a different tmp location

2001-11-26 Thread Martyn Wendon
Hi, Using MySQL 3.23.43 on Red Hat Linux 6.2, is there a way to tell MySQL to use a different "tmp" location? I am having problems indexing a large table as mysql bombs out with an out of disk space error int the /tmp directory (which actually has about 500 megs free space). I know there is a c