Bacula-users

Re: [Bacula-users] Huge MySQL database file

2010-12-09 06:53:37
Subject: Re: [Bacula-users] Huge MySQL database file
From: "Bartosz.C" <bartosz.c AT gmail DOT com>
To: Dan Langille <dan AT langille DOT org>
Date: Thu, 9 Dec 2010 12:51:37 +0100
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.
Bartosz.

On 9 December 2010 12:32, Dan Langille <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.

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

------------------------------------------------------------------------------
This SF Dev2Dev email is sponsored by:

WikiLeaks The End of the Free Internet
http://p.sf.net/sfu/therealnews-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users