[horde] DB backups

Kevin Konowalec webadmin at ualberta.ca
Thu Nov 1 16:45:51 UTC 2007


So since I've set horde to not have a datatree backend, would it hurt  
anything if I was to purge that table?  No point in backing up a table  
full of junk (it's full of legacy data... mostly history stuff that  
got in there before I turned it off).

K



On Nov 1, 2007, at 10:40 AM, Michael Rubinsky wrote:

> 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<mime-attachment>--
> 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



More information about the horde mailing list