[Cialug] mysqldump & /tmp

[Dave Hala Jr]

Mysql is picky about permissions too, so if you're doing something new
that could also be something to look at.

On Tue, 2011-11-22 at 09:34 -0600, Crouse wrote:
> 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
> >
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug