Re: [Bacula-users] Huge MySQL database file

[Bartosz.C <bar...@gm...>]

On 10 December 2010 00:25, Dan Langille <da...@la...> wrote:

> On 12/9/2010 6:51 AM, Bartosz.C wrote:
>
>> On 9 December 2010 12:32, Dan Langille <da...@la...
>> <mailto:da...@la...>> 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/
>

My fault.
By the first: reading with understanding.
1. Everything is ok in data base.
2. The default job named "BackupCatalog" is the clue.
Thank you for help and suggestions.

Bartosz.