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
