On 10/22/10 14:07, mark.berg...@uphs.upenn.edu wrote:
> The pithy ruminations from Phil Stracchino <ala...@metrocast.net> on "Re:
> [Bacula-users] Searching for files" were:
>
> => On 10/22/10 02:47, ladolf wrote:
> => > Maybe anyone knows how to query the bacula database directly to get
> => > search result for a file.
> =>
> => At the simplest possible level: start up bconsole, use the SQL query
> => function, and enter this query:
>
> Wow.
>
> Could you please re-read this, and consider whether this is really the
> "simplest possible level"? I think I understand what you mean, but it's far
> from "simple".
The OP asked for a way to directly query the Bacula DB for a file that
he can only remember part of the filename of. That short one-liner
query in the Filename table really is the simplest way to retrieve full
filenames case-insensitively matching the part he remembers, and the SQL
Query function in bconsole is the simplest way to execute it for someone
not proficient in SQL.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, Free Stater
It's not the years, it's the mileage.
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
