Hi, Thanks for that, I actually managed to work it out for myself. You can create a file "my.cnf" in either /etc or in the root of the mysql data directory that can contain many options. By specifying "tmpdir=/home/mysql/tmpdata" I was able to make mysqld use that location 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 > 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 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 command > > line option --tmpdir but I would prefer a configuration file solution if > > possible. > > > > Many thanks, > > > > Martyn > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > -- > > -·-·-·- > Delfim Machado - [EMAIL PROTECTED] > SAPO :: Serviço de Apontadores Portugueses - http://www.sapo.pt > > 'Calço o 40 e uso Linux' · Edson Medina > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
