Hi Bruno,

You hit the bullz eye!!

I read both the scripts

make_catalog_backup  & delete_catalog_backup.

Found that previous admin has modified this script.

After the statement ,

mysqldump -u ${2}${MYSQLPASSWORD}${MYSQLHOST} -f --opt $1 

He is copying the bacula.sql file onto the location where it is currently has 
grown to 6 GB in size.

I am not sure why he is doing it ... Any guesses?

But I guess I can remove this step and simply delete the bacula.sql ( 6 GB) 
file. 

Please correct me if I am wrong.


Thanx,
Admin 

-----Original Message-----
From: Bruno Friedmann [mailto:bruno AT ioda-net DOT ch] 
Sent: Montag, 18. Oktober 2010 12:59
To: bacula-users AT lists.sourceforge DOT net
Subject: Re: [Bacula-users] Bacula mysql cleanup

On 10/18/2010 11:06 AM, 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.
> 
> Thanx,
> Admin
> 

Normally the bacula.sql file is removed each night after the catalog database 
job
bacula.sql is the pure sql dump file which is pushed in the job catalog 
database.
after that the bacula.sql should/can be remove

here's a typicall catalog job that should be true for a 2.2.7 version

# Backup the catalog database (after the nightly save)
Job {
  Name = "BackupCatalog"
  JobDefs = "DefBackupJob"
  Level = Full
  Client = "yoda-fd"
  FileSet="FileSet_Catalog"
  Pool = "Pool_Catalog"
  Storage = "Store_FSSQL"
  Schedule = "Schedule_QuotidienCatalog"
  # This creates an ASCII copy of the catalog
  RunBeforeJob = "/usr/lib/bacula/make_catalog_backup bacula bacula bacula"
  # This deletes the copy of the catalog --> SEE THAT
  RunAfterJob  = "/usr/lib/bacula/delete_catalog_backup"
  Write Bootstrap = "/var/lib/bacula/BackupCatalog.bsr"
  Priority = 20                                                 # run after 
main backup
}

It seem you miss the RunAfterJob ...



-- 

Bruno Friedmann (irc:tigerfoot)
Ioda-Net Sàrl www.ioda-net.ch
 openSUSE Member
    User www.ioda.net/r/osu
    Blog www.ioda.net/r/blog
  fsfe fellowship www.fsfe.org
GPG KEY : D5C9B751C4653227
vcard : http://it.ioda-net.ch/ioda-net.vcf

------------------------------------------------------------------------------
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

------------------------------------------------------------------------------
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