Re: [Bacula-users] Listing filenames of backed up files
On Thu, 2006-02-23 at 17:51 -0800, Karl Hakimian wrote: On Thu, Feb 23, 2006 at 10:58:03AM +0100, Geir Asle Borgen wrote: On Wed, 2006-02-22 at 06:54 -0800, Karl Hakimian wrote: On Wed, Feb 22, 2006 at 02:58:11PM +0100, Geir Asle Borgen wrote: OK, but I'm no SQL guru ... I'm capable to get in to query-mode (using bconsole) ... But any hint om SQL queryes for MySQL is welcome :) Not sure why you would need to do this directly in sql, but the query in postgres looks like: No need for SQL ... but I can't find the proper way to do this in bconsol ... or any oter tool ... testing the wxconsole-hint from Arno ... and that made me understand that I can use query in bconsol and get the info I need :D Thanks Arno! In bconsole, just issue the command list files jobid=### where ### is the job number you want to look at. I would avoid using sql even through bconsole. Now I only have to tind a way to put this info to a file ... I read some where that bconsole can be run whit options as a normale *nix command ... looking ... have to read ... no prob :) echo list files jobid=### | bconsole -s should run command in bconsole. I attach a shell script that does this for me ... If some one got the same problem :) Thanks folks! -- Phone Work: +47 69212321 / 2321 Phone Priv: +47 69809853 (o_ +47 99521685 / 3137 //\ ICQ: 48948625 MSN: [EMAIL PROTECTED] V_/_ i n u x Registered Linux User # 171776 (http://counter.li.org) getting_backedup_files.sh Description: application/shellscript signature.asc Description: This is a digitally signed message part
Re: [Bacula-users] Listing filenames of backed up files
On Wed, 2006-02-22 at 06:54 -0800, Karl Hakimian wrote: On Wed, Feb 22, 2006 at 02:58:11PM +0100, Geir Asle Borgen wrote: OK, but I'm no SQL guru ... I'm capable to get in to query-mode (using bconsole) ... But any hint om SQL queryes for MySQL is welcome :) Not sure why you would need to do this directly in sql, but the query in postgres looks like: No need for SQL ... but I can't find the proper way to do this in bconsol ... or any oter tool ... testing the wxconsole-hint from Arno ... and that made me understand that I can use query in bconsol and get the info I need :D Thanks Arno! Now I only have to tind a way to put this info to a file ... I read some where that bconsole can be run whit options as a normale *nix command ... looking ... have to read ... no prob :) select Path.path || Filename.name from File, Path, Filename where File.jobid = yourjobnumber and File.pathid = Path.pathid and File.filenameid = Filename.filenameid Replace yourjobnumber with the job number you want the files for. Unless you are coding up some sort of app, I'd suggest sticking with bconsole. -- Phone Work: +47 69212321 / 2321 Phone Priv: +47 69809853 (o_ +47 99521685 / 3137 //\ ICQ: 48948625 MSN: [EMAIL PROTECTED] V_/_ i n u x Registered Linux User # 171776 (http://counter.li.org) signature.asc Description: This is a digitally signed message part
Re: [Bacula-users] Listing filenames of backed up files
On Thu, Feb 23, 2006 at 10:58:03AM +0100, Geir Asle Borgen wrote: On Wed, 2006-02-22 at 06:54 -0800, Karl Hakimian wrote: On Wed, Feb 22, 2006 at 02:58:11PM +0100, Geir Asle Borgen wrote: OK, but I'm no SQL guru ... I'm capable to get in to query-mode (using bconsole) ... But any hint om SQL queryes for MySQL is welcome :) Not sure why you would need to do this directly in sql, but the query in postgres looks like: No need for SQL ... but I can't find the proper way to do this in bconsol ... or any oter tool ... testing the wxconsole-hint from Arno ... and that made me understand that I can use query in bconsol and get the info I need :D Thanks Arno! In bconsole, just issue the command list files jobid=### where ### is the job number you want to look at. I would avoid using sql even through bconsole. Now I only have to tind a way to put this info to a file ... I read some where that bconsole can be run whit options as a normale *nix command ... looking ... have to read ... no prob :) echo list files jobid=### | bconsole -s should run command in bconsole. -- Karl Hakimian [EMAIL PROTECTED] --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Listing filenames of backed up files
On Wed, 2006-02-22 at 14:39 +0100, Arno Lehmann wrote: Hi, On 2/21/2006 8:36 PM, Geir Asle Borgen wrote: Is it possible to genrate a list of the name of files that are backed up during a incremental job on a client. The easiest way would be to use the query List files for a selected JobId and supplying the job ID which is reported in the job results or can be found out with another query. OK, but I'm no SQL guru ... I'm capable to get in to query-mode (using bconsole) ... But any hint om SQL queryes for MySQL is welcome :) I suspect that some one (a user) runs a script that do a touch on a lot of files ... or some thing like that. If I have some lists of filenames from some days I can compare the list and find which files that change every day :) Good luck... of course it might be that the files are actually used. Arno -- Phone Work: +47 69212321 / 2321 Phone Priv: +47 69809853 (o_ +47 99521685 / 3137 //\ ICQ: 48948625 MSN: [EMAIL PROTECTED] V_/_ i n u x Registered Linux User # 171776 (http://counter.li.org) signature.asc Description: This is a digitally signed message part
Re: [Bacula-users] Listing filenames of backed up files
Hi, On 2/22/2006 2:58 PM, Geir Asle Borgen wrote: On Wed, 2006-02-22 at 14:39 +0100, Arno Lehmann wrote: Hi, On 2/21/2006 8:36 PM, Geir Asle Borgen wrote: Is it possible to genrate a list of the name of files that are backed up during a incremental job on a client. The easiest way would be to use the query List files for a selected JobId and supplying the job ID which is reported in the job results or can be found out with another query. OK, but I'm no SQL guru ... No need to be one - others have already done that work! I'm capable to get in to query-mode (using bconsole) ... But any hint om SQL queryes for MySQL is welcome :) Try Baculas canned queries. Use the command 'query' and not 'sqlquery'. For example what I get in wxconsole: #que Available queries: 1: List Job totals: 2: List where a File is saved regardless of the directory: 3: List where the most recent copies of a file are saved: 4: List last 20 Full Backups for a Client: 5: List all backups for a Client after a specified time 6: List all backups for a Client 7: List Volume Attributes for a selected Volume: 8: List Volumes used by selected JobId: 9: List Volumes to Restore All Files: 10: List Pool Attributes for a selected Pool: 11: List total files/bytes by Job: 12: List total files/bytes by Volume: 13: List Files for a selected JobId: 14: List Jobs stored in a selected MediaId: 15: List Jobs stored for a given Volume name: 16: List last 25 Jobs ordered by start time with long status: 17: List which media bacula thinks is in changer: 18: List media metadata concerning life-time 19: List all backups for a client with FileSet: 20: List all Media Choose a query (1-20): Unexpected question has been received. 13 Enter JobId: Unexpected question has been received. 5250 ++--+ | Path | Name | ++--+ | /dev/ | tty10 | | /dev/ | ttyS1 | | /etc/ | | | /etc/ | ntp.drift | | /tmp/ | | | /var/account/ | pacct | etc. Arno -- IT-Service Lehmann[EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Listing filenames of backed up files
Is it possible to genrate a list of the name of files that are backed up during a incremental job on a client. I suspect that some one (a user) runs a script that do a touch on a lot of files ... or some thing like that. If I have some lists of filenames from some days I can compare the list and find which files that change every day :) -- Phone Work: +47 69212321 / 2321 Phone Priv: +47 69809853 (o_ +47 99521685 / 3137 //\ ICQ: 48948625 MSN: [EMAIL PROTECTED] V_/_ i n u x Registered Linux User # 171776 (http://counter.li.org) signature.asc Description: This is a digitally signed message part
