On 10 December 2010 00:25, Dan Langille <d...@langille.org> wrote: > On 12/9/2010 6:51 AM, Bartosz.C wrote: > >> On 9 December 2010 12:32, Dan Langille <d...@langille.org >> <mailto:d...@langille.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/ >
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.
------------------------------------------------------------------------------
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
