On Thu, Mar 26, 2009 at 12:56:02PM +0100, Kern Sibbald wrote: > 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?
I type in a date that is one second greater than the start date of the job that it selects. This possibly restores files that didn't exist at that time, because the backup might have taken a long time to complete. I am just showing how selecting a sequence of jobs by the date is ambiguous, whereas entering the JobId that you want is not. ------------------------------------------------------------------------------ _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
