Op 11/02/2011 10:10, J. Echter schreef: > Am 11.02.2011 09:47, schrieb Valerio Pachera: >> Hi, I'm using bacula 5.0.2 on debian lenny. >> I have this directort definition >> >> Director { # define myself >> Name = control-station-director >> DIRport = 9101 # where we listen for UA connections >> QueryFile = "/etc/bacula/scripts/query.sql" >> WorkingDirectory = "/var/lib/bacula" >> PidDirectory = "/var/run/bacula" >> Maximum Concurrent Jobs = 1 >> Password = "xxxx" # Console password >> Messages = Daemon >> } >> >> And this FileSet that was already configure by debian: >> >> # This is the backup of the catalog >> FileSet { >> Name = "Catalog" >> Include { >> Options { >> signature = MD5 >> compression = GZIP >> } >> File = /var/lib/bacula/bacula.sql >> } >> } >> >> The file /var/lib/bacula/bacula.sql is empty. >> Does bacula save by itself the database in the working directory >> (/var/lib/bacula/) or do I have to dump the database manualy (or by a >> script)? >> Because this FileSet was already presente I thought the dump of >> database was already made by bacula. >> If it should be like that...than I have something not working with my >> director. >> >> Last: what is QueryFile in the director definition? Mine is very >> old...(julay). >> Thank you. >> rceforge.net/lists/listinfo/bacula-users > Hi, > > no there are scripts called make_catalog_backup for example You need a separate job that makes the export of the database, and uses the Catalog fileset, to backup the catalog. An example should be provided in the base config file I believe. This is what I'm using (your installation might have put the scripts elsewhere):
Job { Name = "BackupCatalog" JobDefs = "DefaultLinuxJob" Client = baculatest-fd Level = Full FileSet="Catalog" Schedule = "RunAfterBackup" Max Start Delay = 16h Messages = OnError RunBeforeJob = "/usr/lib/bacula/make_catalog_backup bacula bacula" RunAfterJob = "/usr/lib/bacula/delete_catalog_backup" Max Wait Time = 12h Max Run Time = 15h Max Start Delay = 15h Priority = 12 # run as last job } The beforejob will dump the contents of the bacula catalog using mysqldump (will need another script for postgresql I bet), then it'll get backupped by the job, and afterwards the dump will be deleted again to save space. You can of course opt to use another script to backup the catalog, etc. Kind regards, Jeremy **** DISCLAIMER **** http://www.schaubroeck.be/maildisclaimer.htm ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users