On 12/14/2021 3:08 am, Larry Rosenman wrote:
On 12/14/2021 2:46 am, Wolfgang Denk wrote:
Dear Larry,
In message <0f11700a6a58d852a04b058fabe46...@lerctr.org> you wrote:
>
> In message <6f0199d2227115785c7bcb94e3250...@lerctr.org> you wrote:
>>
>> > I thought I had succesfully run all DB upgrades during that time,
>> > but apparently something is missing:
> ...
>
>> Did you run the bacula database upgrade??
>
> I was sure I did, but maybe I missed one. Do you have a hint, which
> one? And, of this was an older one, how to fix it?
...
there should be a update_bacula_tables script (and it's associated
DB-Specific SQL files)
in the share/ directory from the package.
Yes, I know that. And I _think_ I always ran these scripts (usually
because bacula-dir would complain). But what I see is this:
[snip]
I just re-read your initial problem.
Are you using the most recent version of bconsole?
*restore
Automatically selected Catalog: MyCatalog
Using Catalog "MyCatalog"
First you select one or more JobIds that contain files
to be restored. You will be presented several methods
of specifying the JobIds. Then you will be allowed to
select which files from those JobIds are to be restored.
To select the JobIds, you have the following choices:
1: List last 20 Jobs run
2: List Jobs where a given File is saved
3: Enter list of comma separated JobIds to select
4: Enter SQL list command
5: Select the most recent backup for a client
6: Select backup for a client before a specified time
7: Enter a list of files to restore
8: Enter a list of files to restore before a specified time
9: Find the JobIds of the most recent backup for a client
10: Find the JobIds for a backup for a client before a specified
time
11: Enter a list of directories to restore for found JobIds
12: Select full restore to a specified Job date
13: Cancel
Select item: (1-13): 2
Defined Clients:
1: borg-fd
2: fbsd10-fd
3: ntp-server-fd
4: oldtbh.lerctr.org-fd
5: r610-fd
6: thebighonker-fd
Select the Client (1-6): 1
.zimrc
This is the query that's executing:
SELECT Job.JobId as JobId,Path.Path||File.Filename as Name,
StartTime,Type as JobType,JobStatus,JobFiles,JobBytes FROM
Client,Job,File,Path WHERE Client.Name='borg-fd'
AND Client.ClientId=Job.ClientId AND Job.JobId=File.JobId AND
File.FileIndex > 0 AND Path.PathId=File.PathId AND
File.Filename='.zimrc' ORDER BY StartTime DESC LIMIT 20
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
