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 to not check my work *before* I post...
>
> -- D
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
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/
01-whitesnake-dont_break_my_heart_again.mp3
No database record found for:
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
02-whitesnake-walking_in_the_shadow_of_the_blues.mp3
No database record found for:
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
03-whitesnake-aint_no_love_in_the_heart_of_the_city.mp3
No database record found for:
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
04-whitesnake-ready_an_willing.mp3
No database record found for:
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
05-whitesnake-slide_it_in.mp3
No database record found for:
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
06-whitesnake-love_aint_no_stranger.mp3
No database record found for:
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
07-whitesnake-slow_an_easy.mp3
No database record found for:
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
08-whitesnake-fool_for_your_loving.mp3
No database record found for:
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
09-whitesnake-judgement_day.mp3
No database record found for:
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
10-whitesnake-the_deeper_the_love.mp3
Its a bit strange because the records is extracted from the database,
perhaps it is the format?
This is how they looks in the output file generated by MySql:
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
01-whitesnake-dont_break_my_heart_again.mp3
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
02-whitesnake-walking_in_the_shadow_of_the_blues.mp3
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
03-whitesnake-aint_no_love_in_the_heart_of_the_city.mp3
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
04-whitesnake-ready_an_willing.mp3
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
05-whitesnake-slide_it_in.mp3
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
06-whitesnake-love_aint_no_stranger.mp3
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
07-whitesnake-slow_an_easy.mp3
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
08-whitesnake-fool_for_your_loving.mp3
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
09-whitesnake-judgement_day.mp3
D:/Music/Whitesnake-The_Definitive_Collection-2006-MTD/
10-whitesnake-the_deeper_the_love.mp3
Regards
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
