On Thu, Mar 26, 2009 at 10:26:24AM +0100, Kern Sibbald wrote: > On Thursday 26 March 2009 10:07:03 Graham Keeling wrote: > > On Fri, Mar 13, 2009 at 05:58:05PM +0100, Kern Sibbald wrote: > > > On Friday 13 March 2009 17:40:30 Graham Keeling wrote: > > > > On Fri, Mar 13, 2009 at 04:16:13PM +0100, Kern Sibbald wrote: > > > > > On Friday 13 March 2009 15:37:38 Graham Keeling wrote: > > > > > > For example, I have: > > > > > > JobId Level Date > > > > > > 1 Full 12/03/2009 10:00:00 > > > > > > 2 Incr 13/03/2009 10:00:00 > > > > > > 3 Incr 14/03/2009 10:00:00 > > > > > > 4 Incr 15/03/2009 10:00:00 > > > > > > > > > > > > If I want to restore all the files that were backed up in JobId 3, > > > > > > I have to enter some date between 14/03/2009 10:00:01 and > > > > > > 15/03/2009 09:59:59. Bacula then automatically selects JobIds 1,2,3 > > > > > > and puts you in its tree browsing mode. > > > > > > > > > > > > I would like an option where I could just type in '3' and get the > > > > > > same behaviour. > > > > > > > > In my example above, typing in '3' would select JobIds 1,2,3. > > > > It would not select '4'. > > > > > > Yes, correct. > > > > > > > This strategy is completely unambiguous. Entering a date is not. > > > > > > We do not agree here. > > > > If I had... > > > > JobId Level StartTime EndTime > > 1 Full 12/03/2009 10:00:00 12/03/2009 11:00:00 > > 2 Incr 13/03/2009 10:00:00 13/03/2009 11:00:00 > > 3 Incr 14/03/2009 10:00:00 14/03/2009 11:00:00 > > 4 Incr 15/03/2009 10:00:00 15/03/2009 11:00:00 > > > > ...and I entered the date '14/03/2009 10:00:01' into bconsole's restore > > mechanism, which JobIds are going to be selected? > > Why don't you try it, because I would like to know?
OK, I just did. It chooses JobIds 1,2,3. The following shows my real life jobs - obviously, the times are not so neat in real life... ------------The jobs in the database ---------------- mysql> select JobId,StartTime,EndTime from Job; +-------+---------------------+---------------------+ | JobId | StartTime | EndTime | +-------+---------------------+---------------------+ | 1 | 2009-03-26 10:20:24 | 2009-03-26 10:20:26 | | 2 | 2009-03-26 10:21:05 | 2009-03-26 10:21:06 | | 3 | 2009-03-26 10:22:40 | 2009-03-26 10:24:52 | | 4 | 2009-03-26 10:29:38 | 2009-03-26 10:29:46 | +-------+---------------------+---------------------+ 4 rows in set (0.00 sec) ------snippet from bconsole 'restore' output--------- Select item: (1-12): 6 The restored files will the most current backup BEFORE the date you specify below. Enter date as YYYY-MM-DD HH:MM:SS :2009-03-26 10:22:41 Automatically selected Client: BackupPilot-fd Automatically selected FileSet: NetPilots:BackupPilot:NetPilot +-------+-------+----------+-----------+---------------------+-------------+ | JobId | Level | JobFiles | JobBytes | StartTime | VolumeName | +-------+-------+----------+-----------+---------------------+-------------+ | 1 | F | 421 | 698,400 | 2009-03-26 10:20:24 | backup-0001 | | 2 | I | 9 | 400,171 | 2009-03-26 10:21:05 | backup-0002 | | 3 | I | 9 | 6,447,709 | 2009-03-26 10:22:40 | backup-0003 | +-------+-------+----------+-----------+---------------------+-------------+ You have selected the following JobIds: 1,2,3 ------------------------------------------------------------------------------ _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
