Re: [Bacula-users] Restore from a file listing

2010-10-07 Thread Dan Langille
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

2010-10-07 Thread Rory Campbell-Lange
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

2010-10-05 Thread Rory Campbell-Lange
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

2010-10-04 Thread Graham Keeling
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

2010-10-04 Thread Rory Campbell-Lange
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