I was using this script before implementing bacula -
http://sourceforge.net/projects/automysqlbackup/.
ZK
--- David Logan <[EMAIL PROTECTED]> wrote:
> Genís Pujol wrote:
> >
> > Hi all,
> >
> > I have to backup a mysql database and was
> wondering what the best
> > method would be. Schedule a mysqldump some minutes
> before the bacula
> > backup starts? Or with Bacula you dont need to
> dump the mysql databases?
> >
> > Thanks in advance, Ill summarize.
> >
> > Cheers,
> >
> > **Genís Pujol**
> >
> Hi Genis,
>
> I have a small script which runs on the host and is
> in the run-before
> configuration item for that host.
>
> eg :
> Job {
> Name = "Porkchop"
> Type = Backup
> Client = porkchop-fd
> FileSet = "Full porkchop"
> Schedule = "Daily"
> Storage = DLT-HP
> Messages = Standard
> Level = Incremental
> Pool = DLT-Incr
> ClientRunBeforeJob="/usr/local/sbin/backup_db.sh"
> Write Bootstrap = "/usr/local/backup/porkchop.bsr"
> Priority = 10
> SpoolData = yes
> }
>
> The backup script is a shell script which does a
> mysqldump of each
> database into a directory that is then backed up
> after completion. I
> exclude the mysql data directory.
>
> Regards
>
>
> --
>
> David Logan
> South Australia
>
> when in trouble, or in doubt
> run in circles, scream and shout
>
>
>
>
-------------------------------------------------------
> All the advantages of Linux Managed Hosting--Without
> the Cost and Risk!
> Fully trained technicians. The highest number of Red
> Hat certifications in
> the hosting industry. Fanatical Support. Click to
> learn more
>
http://sel.as-us.falkag.net/sel?cmd=lnk&kid7521&bid$8729&dat1642
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
>
https://lists.sourceforge.net/lists/listinfo/bacula-users
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
