Hi,
On 13.11.2005 12:44, Sonia Hamilton wrote:
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)?
That depends on what you want (and where you've got the space to dump
your databases).
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.
One possibility.
If you don't want to shut down your DB, you could also use mysqlhotcopy,
mysqldump or pg_dump and pg_dumpall.
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?
Yes.
For this scenario, you need the dump programs and client libraries of
your DB on the local machine, set up access rights to the databases you
want to backup (usually, you need more rights than expected for a dump,
and don't forget you wll also want to restore - granting all rights for
the backup user on the backup machine is usually ok, IMO).
Then you only need a file set that stores your dumps. The job you use
could also store ldap databases - those are often overlooked but also
important.
To save space, you can also dump your databases to a FIFo and store what
you read from it. This needs some tweaking, but there are examples in
the manual (I believe), and this has recently been discussed on the lists.
Arno
Thanks for any help...
[1] http://www.bacula.org/dev-manual/Configuring_Director.html
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
