On Dec 21, 2012, at 12:46 PM, Joseph De Nicolo wrote:
> Hey Bacula Users,
>
> This should be an easy question for some body with bacula experience.
>
> I need to run a script that will backup my web server's mysql database. The
> script works great, using mysqldump.
> The web server and backup server are two different dedicated machines, hence
> the backup system is "off-site".
> The script needs to run before the backup job obviously, but only on the
> client, and the job should continue whether its successful or fails.
> Here is my script:
>
> RunScript {
> Command = "/var/backupmysql.sh"
> RunsWhen = Before
> RunsOnFailure = yes
> RunsOnClient = yes
> RunsOnSuccess = yes
> }
>
> Now my question is.. should my script(backupmysql.sh) be located on the
> backup system only, the client only, or both? I'm not sure if bacula takes
> the script locally and ports it over to the client or if it searches fo the
> script on the client itself. I hope you understand what I'm talking about.
> Appreciate the help.
It can be where ever you can run mysqldump.
I suggest it should be on the same machine as the MySQL server. i.e. the client
Also: I suggest not deleting the dumped file after the backup. I suggest
leaving it there, in case you need it. Faster than doing a restore.
I also suggest copying that file, and all your bacula *.conf files to another
location, or two, or three. I do that on a daily basis.
--
Dan Langille - http://langille.org
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|