Re: [Bacula-users] Restore from a file listing
On 10/5/2010 2:53 PM, Rory Campbell-Lange wrote: Other than Graham's note about how to escape files I'd be grateful to know if there is another way of marking files so that they can be restored. I simply can't find a way of marking files easily from the root of the restore console (see example below). Can marking be done through SQL? I note that the file table has a markid column. Thanks Rory On 04/10/10, Rory Campbell-Lange (r...@campbell-lange.net) wrote: At present I am doing a restore job by using option 3 and entering the job id as all our backups are full backups. Then I go into the restore console. For each file I want to retrieve I find I have to walk the directory tree to mark the file. mark /survey/GTC/02_SURVEY/02 Graphics/A Exisiting Site Images/GTC_40_ContactSheet-002.pdf doesn't seem to work. Is there a simple and accurate way of providing a list of files of this sort to Bacula in order to mark them and proceed with a restore job? Have you tried scripting it? echo command | bconsole Extensive use of this is done within the regression tests. -- Dan Langille - http://langille.org/ -- Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Restore from a file listing
On 07/10/10, Dan Langille (d...@langille.org) wrote: On 10/5/2010 2:53 PM, Rory Campbell-Lange wrote: Is there a simple and accurate way of providing a list of files of this sort to Bacula in order to mark them and proceed with a restore job? Have you tried scripting it? echo command | bconsole Extensive use of this is done within the regression tests. Thanks very much for the pointer. Regards Rory -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928 -- Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Restore from a file listing
Other than Graham's note about how to escape files I'd be grateful to know if there is another way of marking files so that they can be restored. I simply can't find a way of marking files easily from the root of the restore console (see example below). Can marking be done through SQL? I note that the file table has a markid column. Thanks Rory On 04/10/10, Rory Campbell-Lange (r...@campbell-lange.net) wrote: At present I am doing a restore job by using option 3 and entering the job id as all our backups are full backups. Then I go into the restore console. For each file I want to retrieve I find I have to walk the directory tree to mark the file. mark /survey/GTC/02_SURVEY/02 Graphics/A Exisiting Site Images/GTC_40_ContactSheet-002.pdf doesn't seem to work. Is there a simple and accurate way of providing a list of files of this sort to Bacula in order to mark them and proceed with a restore job? -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928 -- Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Restore from a file listing
On Mon, Oct 04, 2010 at 12:00:12PM +0100, Rory Campbell-Lange wrote: We provide clients with a Bacula backup-to-tape service, which is complementary to our offsite backup services. As part of the backup-to-tape service we wish to audit each tape by checking that we can retrieve several files from each tape in the backup set. Our audit programme (a python script) produces a listing of files suitable for the audit in the format below. The listing is presently made to show the tape name, filename and base64 md5sum. Many of the file names have odd characters in them. At present I am doing a restore job by using option 3 and entering the job id as all our backups are full backups. Then I go into the restore console. For each file I want to retrieve I find I have to walk the directory tree to mark the file. mark /survey/GTC/02_SURVEY/02 Graphics/A Exisiting Site Images/GTC_40_ContactSheet-002.pdf doesn't seem to work. I don't know if this is helpful to you, but the way I do this (with a script) is: path=/your/path/to/file.abc dir=${path%/*} file=${path##*/} (then in bconsole) cd $dir mark $file Bear in mind, last time I checked, bconsole has a very eccentric way of quoting things. And the 'cd' quoting is different to the 'mark' quoting. For 'cd', you need to quote '\' and '' with '\'. For 'mark': '\' needs '\\\'. '' needs '\'. '*', '?' and '[' need '\\'. Is there a simple and accurate way of providing a list of files of this sort to Bacula in order to mark them and proceed with a restore job? Advice gratefully received. Regards Rory ZA-09 : /survey/GTC/02_SURVEY/02 Graphics/A Exisiting Site Images/GTC_40_ContactSheet-002.pdf : BxtAuFFc/f1ad9KAu6QcTA ZA-09 : /survey/GTC/02_SURVEY/01 Draw/05 3d/_Mark/03_renders/elements/viewno02_VRay_RenderID.tif : +uXYLMX+dzF3tagX1HLxGA ZA-09 : /survey/GTC/02_SURVEY/01 Draw/05 3d/_Mark/03_renders/elements/viewno03_VRay_SampleRate.tif : 8mV7L15K2oD8Myl3RHGH1g ZA-09 : /survey/GTC/02_SURVEY/02 Graphics/A Exisiting Site Images/080605_site visit/IMG_0153.JPG : Bffxysn05Jf835pjn8EhWg ZA-09 : /survey/GTC/02_SURVEY/01 Draw/09 Details/A_DE_L.dgn : 8n6FPZ8LUOvd2j0yhpe5Jw ZA-09 : /survey/GTC/02_SURVEY/02 Graphics/A Exisit Images/00_site visit/IMG_0207.JPG : Lc1l+Npa3fAWR7dG7UNtbw ZA-10 : /survey/USA2/Design/Graphics/99_SCM/Material/Elevation.pdf : cO4XMEdlCtdI7g9wL5B/Dg ZA-10 : /survey/USA2/Design/Graphics/99_SCM/Material/added to binder/ this.pdf: KSNJEaQHmW0+xvrqjFFmog ZA-10 : /survey/USA2/Design/Graphics/99_A Visit_mplan/Material/uerplan_A1_130208.indd : kKBqVl5Dh9elOe1HeXqMDw ZA-10 : /survey/USA2/Design/Graphics/99_B/material/Coloured/WR_MultiBay_with_Stair.pdf : Rk43I9cB+hkWAd+BHNrzkQ ZA-10 : /survey/USA2/Design/Graphics/99_C/Material/corner sketch.pdf : 723kZeU7rY5l7620SWwS0w ZA-10 : /survey/USA2/Design/Graphics/99_phased/Material/Finished JPEGs/phase 5.jpg : 5R+Mvs0JsQW+RtWUo6SIXg ZA-10 : /survey/USA2/Design/Graphics/99_SCM/Material/for binder/elevations 4dec08.pdf : G2AOwxxYs8PnuJuxpdJY3A ZA-10 : /survey/USA2/Design/Graphics/99_SCM/Material/east_flatroof_sketch.pdf : 8cOmdPhe+Hgkkxb60l+0og ZA-10 : /survey/USA2/Design/Graphics/99_SCM/Material/A_nnn_ East-West_OR.pdf : XrGzU07JjrWevaxWDUjMNQ ZA-10 : /survey/USA2/Design/Graphics/99_meeting/A___Typical_bay.pdf : vM0DRH5xevICHlVxKg3elg ZA-11 : /issue/ZAN/OUT/ISSUES/IN_Scheme updated/PDF/_LongSect250.tiff : TySX9plPTq4uIy05iwY5fA ZA-11 : /issue/ZAN/OUT/ISSUES/IN_DWG/IN/1527.dwg : ew1rXI6UJoLmizY4wvIUrw ZA-11 : /issue/ZAN/OUT/ISSUES/IN0/DGN/0005.dgn : n040KyL8cX9crgpY9asLfg ZA-11 : /issue/ZAN/OUT/ISSUES/IN0/ff=/0004.dgn : V2jTeupRp3Yv1qmpteDnWw ZA-11 : /issue/ZAN/OUT/ISSUES/IN0_Construction issue/15L9.hpgl : 8fOJdGO5SwaOMkxNi43kxg ZA-11 : /issue/ZAN/OUT/ISSUES/IN0_ZAN/A_ZAN.pdf : v+oAaYnWv+1Bjq5ezWgmlg ZA-11 : /issue/ZAN/OUT/ISSUES/IN0_arch/1000_.000 : ODbF++krYYWMLsBmI/GgRQ ZA-11 : /issue/ZAN/OUT/ISSUES/IN0_Engage Plan/copy/3002.dwg : O+haqF++WUp519AnX+q1uQ ZA-11 : /issue/ZAN/OUT/ISSUES/IN0_DWGs/1515.bak : Ca7aA7v95BNv+rK6HoyvYA ZA-11 : /issue/ZAN/OUT/ISSUES/IN0_Construction issue southblock/Binder1.pdf : K/iqrW28Z+Lemk4osfrnCQ -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop
Re: [Bacula-users] Restore from a file listing
On 04/10/10, Graham Keeling (gra...@equiinet.com) wrote: On Mon, Oct 04, 2010 at 12:00:12PM +0100, Rory Campbell-Lange wrote: ... At present I am doing a restore job by using option 3 and entering the job id as all our backups are full backups. Then I go into the restore console. For each file I want to retrieve I find I have to walk the directory tree to mark the file. mark /survey/GTC/02_SURVEY/02 Graphics/A Exisiting Site Images/GTC_40_ContactSheet-002.pdf doesn't seem to work. I don't know if this is helpful to you, but the way I do this (with a script) is: path=/your/path/to/file.abc dir=${path%/*} file=${path##*/} (then in bconsole) cd $dir mark $file Bear in mind, last time I checked, bconsole has a very eccentric way of quoting things. And the 'cd' quoting is different to the 'mark' quoting. For 'cd', you need to quote '\' and '' with '\'. For 'mark': '\' needs '\\\'. '' needs '\'. '*', '?' and '[' need '\\'. Thanks very much for your notes, Graham. Aaargh! I'll give those quoting patterns a go. It would be fantastically useful to be able to pipe file names to a Bacula restore process. -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928 -- Virtualization is moving to the mainstream and overtaking non-virtualized environment for deploying applications. Does it make network security easier or more difficult to achieve? Read this whitepaper to separate the two and get a better understanding. http://p.sf.net/sfu/hp-phase2-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users