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

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 MySQL