[horde] DB backups

[Michael Rubinsky]

Quoting Kevin Konowalec <webadmin at ualberta.ca>:

>
> 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?

That depends on your particular installation.

I've set it to not use
> any back end for datatree storage.  What is the datatree for, anyway?

The datatree is used in a number of places...the share system, the  
permissions system, some applications use it for data  
storage...probably more that I'm forgetting....


Thanks,
mike

--
The Horde Project (www.horde.org)
mrubinsk at horde.org

"Time just hates me. That's why it made me an adult." - Josh Joplin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: PGP Digital Signature
Url : http://lists.horde.org/archives/horde/attachments/20071101/9420d4ec/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 2013 bytes
Desc: PGP Public Key
Url : http://lists.horde.org/archives/horde/attachments/20071101/9420d4ec/attachment-0001.bin