Re: [Bacula-users] Huge MySQL database file

[Dan L. <da...@la...>]

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/