List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:January 11 2000 5:24pm
Subject:RE: answer: How to change tmp directory for mysql
View as plain text  
>>>>> "SP" == Steve Pennington <admin@stripped> writes:

SP> Thanks everyone for the help. I tried running mysql with the command
SP> line --tmpdir=/home/tmp but isamchk still used /tmp. I think it just uses
SP> the system variable. I had tmp mounted on a seperate partition so I
SP> unmounted it and made a symlink to a bigger partition and that seems to have

You probably want to tell isamchk which tmpdir to use, as it does not
contact the server to do its work.  Telling mysqld to use an alternate
tmpdir will only affect mysqld when it creates a temp table, which is
not when running isamchk.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-301-545-6996
PGP & MIME spoken here            http://www.kciLink.com/home/khera/
Thread
How to change tmp directory for mysqlSteve Pennington11 Jan
  • answer: How to change tmp directory for mysqlSasha Pachev11 Jan
    • Re: answer: How to change tmp directory for mysqlVivek Khera11 Jan
      • RE: answer: How to change tmp directory for mysqlSteve Pennington11 Jan
        • RE: answer: How to change tmp directory for mysqlVivek Khera11 Jan
        • Re: answer: How to change tmp directory for mysqlSasha Pachev11 Jan
  • Re: How to change tmp directory for mysqlmiguel angel sol√≥rzano11 Jan
  • Re: answer: How to change tmp directory for mysqlThayne Harbaugh11 Jan
Re: answer: How to change tmp directory for mysqlRyan Caveney11 Jan
RE: answer: How to change tmp directory for mysqlJohn Foley11 Jan