[horde] DB backups

[Kevin Konowalec]

On Oct 30, 2007, at 10:01 PM, Vilius Sumskas wrote:

>> Ya I looked at that.  It's permitted correctly.   It's got 4Gigs free
>> - maybe somehow it wants more then that (the horde db is about
>> 700MB).  The question then becomes how do you get mysqldump to use a
>> different temp space?
>
> MySQL uses TMPDIR environment variable, so if you want to use  
> different directory you should change that variable for the user you  
> are trying to export with.
>
> -- 
>  Best Regards,
>
>  Vilius
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>



Didn't work.  I tried to use /var/tmp as my value for TMPDIR.  It has  
600G free so I know there's enough space.  But now I get:

mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'horde\_datatree'':  
Can't create/write to file '/tmp/#sql_91_0.MYI' (Errcode: 24) (1)


different error code... but same error.  And it still seems to be  
trying to write to /tmp despite having the environment variable set.

Thing is... do I even need the datatree table?  I've set it to not use  
any back end for datatree storage.  What is the datatree for, anyway?

K