Hi, Just curious, but is there a reason you did it this way around instead of having a 'ClientRunBeforeJob' script launch the dump process from within Bacula?
You end up with the same result in the end I guess and I was wondering if there was more to it than just personal preference. Cheers, Troy. David Romerstein wrote: > On Mon, 30 Jul 2007, Dimitrios wrote: > >> I'm already using mysqldump to create archives of my database, but i >> don't see how Bacula can execute mysqldump during its backup process. >> I'll search the docs to see if there is support for such a thing. > > Reverse your thinking - let your mysqldump process execute bacula. > > I'm running two MySQL servers, one slaved to the other. I take my backups > from the slave, which is rarely more than 60 seconds behind the master. > I've got a cron job that calls a script that does the following: > > 1) Checks if this is an odd or even week. I only want backups every two > weeks > 2) Deletes the backup on disk from 4 weeks ago and moves the backup from > two weeks ago to 'backup.old' > 3) Stops the slave process > 4) Locks the tables > 5) Using mysqldump, dumps all tables from all databases to a known backup > folder, '/data/staging/mysql_backup', gzipping them along the way > 6) Restarts the slave process > 7) Calls bacula to run the backup job 'backup_database', which has > '/data/staging/mysql_backup' as its Fileset: > > /etc/bacula/bconsole -c /etc/bacula/bconsole.conf <<END_OF_DATA > run job=backup_database yes > END_OF_DATA > > In the end, I have a copy of the databases on tape and two copies on a > RAID device separate from where the database resides. > > -- D, who sometimes wears both a belt and suspenders > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
