On Feb 13, 2007, at 7:35 PM, David Romerstein wrote:
Yeah, I think I mentioned in my original mail that there were going
to be
TAB characters between the columns in the output. You're on Windows...
there are a number of text file editors that will handle this (my
favorite
is Textpad - www
On Wed, 14 Feb 2007, Thor Vik wrote:
> I am not sure whats wrong but your query lists out all my MP3 files fine in
> to the output file. But when importing to restore in bacula I get these
> messages:
>
> No database record found for:
> D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
David Romerstein skrev:
> I have this bass ackwards, and I screwed up a column name.
>
> SELECT p.Path, fn.Name FROM Path p, Filename fn, File f WHERE
> fn.Name LIKE '%.mp3' AND f.FilenameID = fn.FilenameID and p.PathID =
> f.PathID INTO OUTFILE '/tmp/mp3_filez.out';
>
> *sigh* - that'll teach me
On Tue, 13 Feb 2007, David Romerstein wrote:
> SELECT p.Path, fn.Filename FROM p Path, fn Filename, f File WHERE
> fn.Filename LIKE '%.mp3' AND f.FilenameID = fn.FilenameID and p.PathID =
> f.PathID INTO OUTFILE '/tmp/mp3_filez.out';
Ugh.
I have this bass ackwards, and I screwed up a column name
On Tue, 13 Feb 2007, Thor Vik wrote:
> Does anyone know of a good SQL guide to restore files for bacula? I want
> to restore eg. all mp3 files (*.mp3) and want to write sql for this. :-)
My first thought (not having done a lot of multi-file restores in Bacula)
is that you'd probably want to dump
Does anyone know of a good SQL guide to restore files for bacula? I want
to restore eg. all mp3 files (*.mp3) and want to write sql for this. :-)
Regards
Wingthor
-
Using Tomcat but need to do more? Need to support web serv
