[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] pruning - using relational integrity


Bill Moran wrote:
> In response to Dan Langille <dan@xxxxxxxxxxxx>:
> 
>> I'm a big fan of relational integrity.  If you delete a job from the  
>> Job table, everything
>> should magically disappear from the database.
>>
>> This approach should greatly simplify the pruning.
> 
> Unfortunately, it won't work with MySQL/MyISAM, which I suspect is
> pretty popular for use as a Bacula back end.

True, but it's quite straightforward to change a MyISAM table over to an
InnoDB one, without any data loss.

-- 
Frank Sweetser fs at wpi.edu  |  For every problem, there is a solution that
WPI Senior Network Engineer   |  is simple, elegant, and wrong. - HL Mencken
    GPG fingerprint = 6174 1257 129E 0D21 D8D4  E8A3 8E39 29E3 E2E8 8CEC

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilot Consulting.