On Thursday 26 March 2009 11:39:50 Graham Keeling wrote: > 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 >
That seems good to me as I was hoping. It appears that Bacula is doing the selection correctly. Do you have a problem with it? ------------------------------------------------------------------------------ _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
