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
mich...@highpoweredhelp.com

-----Original Message-----
From: Dimitri Maziuk [mailto:dmaz...@bmrb.wisc.edu] 
Sent: Friday, January 29, 2016 10:53 AM
To: bacula-users@lists.sourceforge.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to