I'm trying to backup a couple of remote mysql and postgres databases using the RunBeforeJob directive. However I can't work out from the doco [1] how to use this directive.
I have 2 machines foo and bar, foo running director foo-dir, and bar running file daemon bar-fd and a mysql database. Should the script called by RunBeforeJob be located on foo (director) or bar (remote machine)? If the script is on the remote machine (bar), I can understand it would just stop the db, dump it to a file, and restart the db. If the script is run on the local machine (foo), how would it backup the remote database? Connect remotely to the db server, get it to dump to a file on the remote machine, then grab that file as part of the normal backup? Thanks for any help... [1] http://www.bacula.org/dev-manual/Configuring_Director.html -- Sonia Hamilton. GPG key A8B77238. . Veni Vidi Linux!
signature.asc
Description: OpenPGP digital signature