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 mich...@highpoweredhelp.com -----Original Message----- From: Michael Munger [mailto:mich...@highpoweredhelp.com] Sent: Friday, January 29, 2016 10:59 AM To: Dimitri Maziuk <dmaz...@bmrb.wisc.edu>; bacula-users@lists.sourceforge.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 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 ------------------------------------------------------------------------------ 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
