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
