Re: [Bacula-users] Bacula mysql cleanup
2010-10-18 07:01:57
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
|
|
|