[Cialug] mysqldump & /tmp

[Crouse]

This might prove helpful.
http://dev.mysql.com/doc/refman/5.0/en/temporary-files.html

"On Unix, MySQL uses the value of the TMPDIR environment variable as
the path name of the directory in which to store temporary files. If
TMPDIR is not set, MySQL uses the system default, which is usually
/tmp, /var/tmp, or /usr/tmp. "

"If the file system containing your temporary file directory is too
small, you can use the --tmpdir option to mysqld to specify a
directory in a file system where you have enough space. "



On Tue, Nov 22, 2011 at 8:50 AM, Dave Hala Jr <dave at 58ghz.net> wrote:
> I've never had that problem with mysql 3.x,4.x or 5.x and I do lots of
> automated dumps.
>
> On Tue, 2011-11-22 at 08:36 -0600, L. V. Lammert wrote:
>> Getting a weird error when running a mysqldump, it was suggested that
>> mysqldump meeds space in /tmp [which is low on space with this old
>> machine], but I am not sure if/why and cannot find any specifigs.
>>
>> Can anyone confirm that mysql dump requires space in /tmp even if output
>> is redirected elsewhere?
>>
>>       Lee
>> _______________________________________________
>> Cialug mailing list
>> Cialug at cialug.org
>> http://cialug.org/mailman/listinfo/cialug
>
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>