Hello,

I agree if I rename just the file name in bacula-dir.conf , it will start to 
write in a new file.
But the point is the file which has grown in size is "bacula.sql".
So this is the actual file in question. Can we do something about this file?


Thanx,
Admin

-----Original Message-----
From: Damian Ge;bicki [mailto:damiang AT wasko DOT pl] 
Sent: Montag, 18. Oktober 2010 11:26
To: Holikar, Sachin (ext)
Cc: bacula-users AT lists.sourceforge DOT net
Subject: Re: [Bacula-users] Bacula mysql cleanup

Holikar, Sachin (ext) wrote:
> Hello,
>  
> We have a Bacula  Version: 2.2.7 installed on SuSE 9 Linux. The database 
> is mysql  Ver 14.7.
>  
> Bacula has been running since couple of years now. We noticed that the 
> mysql partition where "Write Bootstrap" files (*.bsr) are stored is 
> increased alot.
> Particularly "bacula.sql" file is grown to 6 GB now. Which is the 
> *backup of the catalog file.*
> ** 
> Now,
>  
> 1>    Is there anyway we can move this (and other .bsr) files to 
> someother location having large space without affecting Bacula 
> functionality?
> 2>    Can we somehow reduce the size of this file? Compression ?
> 
> Please let me know if you require any more information.
>  

.bsr
Did you look into this file?
Its looks like scheduler do only Incremental backup of Catalog database.
Just try to rename this file and new record will be write to new one 
after next CatalogDB backup.

-- 
=========================
Damian

------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users