Bacula-users

Re: [Bacula-users] How do you search for a file in a backup?

2016-01-29 14:00:57
Subject: Re: [Bacula-users] How do you search for a file in a backup?
From: Michael Munger <michael AT highpoweredhelp DOT com>
To: Dimitri Maziuk <dmaziuk AT bmrb.wisc DOT edu>, "bacula-users AT lists.sourceforge DOT net" <bacula-users AT lists.sourceforge DOT net>
Date: Fri, 29 Jan 2016 18:59:06 +0000
Really. The table Filename, for example, has two columns:
FilenameId INT(10)
Name BLOB

Michael Munger, dCAP, MCPS, MCNPS, MBSS
High Powered Help, Inc.
Microsoft Certified Professional
Microsoft Certified Small Business Specialist
Digium Certified Asterisk Professional
michael AT highpoweredhelp DOT com

-----Original Message-----
From: Dimitri Maziuk [mailto:dmaziuk AT bmrb.wisc DOT edu] 
Sent: Friday, January 29, 2016 10:53 AM
To: bacula-users AT lists.sourceforge DOT net
Subject: Re: [Bacula-users] How do you search for a file in a backup?

On 01/29/2016 12:31 PM, Michael Munger wrote:

> (I tried to use MySQL Workbench to do a search on the actual database, 
> but everything is stored as a blob…

Really? On postgres,
select p.path from path p join file f on f.pathid=p.pathid join filename n on 
n.filenameid=f.filenameid where n.name='foo.dat';

--
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users