On 12/9/2010 6:51 AM, Bartosz.C wrote:

On 9 December 2010 12:32, Dan Langille <dan AT langille DOT org

<mailto:dan AT langille DOT org>> wrote:

   On 12/9/2010 6:15 AM, Bartosz.C wrote:

       Hi,
       I have Bacula backup + MySQL database for Bacula. It works about
       half year.
       I have noticed that file of database has 160GB. Is there any
       option to
       reduce this size.
       I think that most information in this file is useless - fe
       backup that
       no longer exist.
       How to reduce size of that database file?
       Can I configure Bacula that it can be deleted themselvs such no
       needed data?
       Bartosz.


   Look at the prune / auto prune directives.

   --

> In my config in every Client and Pool content is AutoPrune = yes
>
> Client {
>    Name = waw-samba-fd
>    Address = 192.168.201.5
>    FDPort = 9102
>    Catalog = MyCatalog
>    Password = "xxx"          # password for FileDaemon
>    File Retention = 30 days            # 30 days
>    Job Retention = 6 months            # six months
>    AutoPrune = yes                     # Prune expired Jobs/Files
> }
>
> ################## end of clients ###################
>
>
> ################## Pools #####################
>
> Pool {
>    Name = sys_waw_samba_codz
>    Pool Type = Backup
>    Recycle = yes
>    AutoPrune = yes
>    Volume Retention = 6 days
>    Maximum Volume Jobs = 1
>    Label Format = sys_waw_samba_codz-
>    Maximum Volumes = 8
> }
>
> And so on, and so on on every Clients and Pools. But it not working
> like I think it should.

Replying at the bottom keeps everything in easily-read order.

According to this, everything older than 6 days will be pruned from the database.  Are your job emails showing something similar to this:


09-Dec 07:58 bacula-dir JobId 41183: Begin pruning Jobs older than 3 years .
09-Dec 07:58 bacula-dir JobId 41183: No Jobs found to prune.
09-Dec 07:58 bacula-dir JobId 41183: Begin pruning Jobs.
09-Dec 07:58 bacula-dir JobId 41183: No Files found to prune.
09-Dec 07:58 bacula-dir JobId 41183: End auto prune.

But, hopefully, finding something to prune.

--
Dan Langille - http://langille.org/