Bacula-users

Re: [Bacula-users] save DB's online

2013-01-17 04:57:55
Subject: Re: [Bacula-users] save DB's online
From: Uwe Schuerkamp <uwe.schuerkamp AT nionex DOT net>
To: Sven Gehr <mailingliste AT dreampixel DOT de>
Date: Thu, 17 Jan 2013 10:55:54 +0100
On Thu, Jan 17, 2013 at 10:40:26AM +0100, Sven Gehr wrote:
> Hi@all,
> 
> is it possible to backu databases e.g. mysql, pgsql (on other hosts) 
> with bacula online?
> 
> -- 
> Viele Grüsse
> 
> Sven Gehr
> 


Yes and no. If there are no jobs running you can set the db to read
only, but bacula will barf the next time it tries to insert something
into the tables. 

A frequently quoted method is creating an lvm snapshot and using a
tool like "mydumper" to create the backup. I don't know about postgres
as we're using mariadb exclusively with bacula ATM. 

Cheers, Uwe 

-- 
NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA



------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users