Kindly disregard this post.

MySQL Workbench detects the Name field as a BLOB type, and so, promptly 
displays this as if I wanted to look at hex / binary data.

When searching from the CLI, the filenames are readily apparent.

Incidentally, from the make_mysql_tables:

--Note, we use BLOB rather than TEXT because in MySQL,
--BLOBs are identical to TEXT except that BLOB is case
--Sensitive in sorts, which is what we want, and TEXT
--Is case insensitive.

Having read this, and your comment about Postgres, I decided to do the query 
directly in the CLI, which revealed this was a Workbench display issue not a 
Bacula issue.


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: Michael Munger [mailto:michael AT highpoweredhelp DOT com] 
Sent: Friday, January 29, 2016 10:59 AM
To: Dimitri Maziuk <dmaziuk AT bmrb.wisc DOT edu>; bacula-users AT 
lists.sourceforge DOT net
Subject: Re: [Bacula-users] How do you search for a file in a backup?

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
------------------------------------------------------------------------------
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