On Thu, Apr 11, 2013 at 08:44:01AM +0000, Eggert, Lars wrote: > Hi, > > On Apr 11, 2013, at 10:30, Baptiste Daroussin <b...@freebsd.org> wrote: > > First, I think you can recover your database. > > that would be great. > > > Can you try the following command: > > > > # mv /var/db/pkg/local.sqlite /var/db/pkg/backup.sqlite > > # echo '.dump' | pkg shell /var/db/pkg/backup.sqlite | pkg shell > > That step doesn't quite work: > > [root@stanley /usr/home/elars/local/db]# echo '.dump' | pkg shell > backup.sqlite | pkg shell > Error: near line 15927: column path is not unique > Error: near line 15928: column path is not unique > Error: near line 15929: column path is not unique > Error: near line 15930: column path is not unique > Error: near line 15931: column path is not unique > Error: near line 15932: column path is not unique > Error: near line 15933: column path is not unique > Error: near line 15934: column path is not unique > Error: near line 15935: column path is not unique > Error: near line 15936: column path is not unique > Error: near line 15937: column path is not unique > > [root@stanley /usr/home/elars/local/db]# ll local.sqlite > -rw-r--r-- 1 root wheel 0 Apr 11 10:42 local.sqlite > > I can send you the database off-list, if you like. > Yes please.
regards, Bapt
pgp2civlZAOdQ.pgp
Description: PGP signature