[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.
Bacula-devel mailing list

This mailing list archive is a service of Copilot Consulting.