Thread: Bacula MySQL database size increasing

hi all,
have been using bacula backup several servers. recently, backupcatalog job takes long finish. i'm pretty sure it's related size of bacula.sql file.

code:

ls root@servername:/var/lib/bacula# ls -l -rw------- 1 bacula bacula 208285783 2012-01-10 05:23 bacula.sql

i've been reading bacula catalog manual here: http://www.bacula.org/3.0.x-manuals/...og/catalog.pdf
, in 1.2 compacting mysql database section, it's talking compacting database:
have been handed server previous guy , don't have info required access mysql database.
part of bacula-dir.conf has reference bacula.sql:

code:

# backup of catalog fileset {   name = "catalog"   include {     options {       signature = md5     }     file = "/var/lib/bacula/bacula.sql"   } }

can please let me know how can compact bacula database?
thanks,
t

terminal >

code:

du -sh /var/lib/mysql/bacula/

Forum The Ubuntu Forum Community Ubuntu Official Flavours Support General Help [ubuntu] Bacula MySQL database size increasing

Ubuntu