[Bug 269810] ports-mgmt/pkg: how to restore pkg database

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=269810

--- Comment #2 from mfv@bway.net ---
Hello Graham,

Thanks for the quick response.  I tried: 'xzcat /var/backups/pkg.sql.xz | pkg
shell'

but ended up with the exact same result.  Here is a directory listing of
/var/db/pkg:

-rw-r--r--  1 root  wheel         158  2023.Feb.16  19:56:30  FreeBSD.meta
-rw-r--r--  1 root  wheel  58,900,480  2023.Feb.25  08:53:06  local.sqlite
-rw-r--r--  1 root  wheel  63,741,952  2023.Feb.23  13:13:34  local.sqlite.one
-rw-r--r--  1 root  wheel  54,980,608  2023.Feb.16  19:56:30 
repo-FreeBSD.sqlite
-rw-r--r--  1 root  wheel           0  2023.Feb.18  09:46:13 
repo-FreeBSD.sqlite-journal
-r--r--r--  1 root  wheel   7,449,709  2023.Feb.25  07:51:28  vuln.xml
-r--r--r--  1 root  wheel   6,316,391  2020.Aug.25  16:53:50  vuln.xml.org

local.sqlite.one is the original file and local.sqlite was created by the xzcat
command.  There original file is 4,841,472 bytes larger than the file created
by '/usr/local/etc/periodic/daily/411.pkg-backup'.

Let me know if I should send additionl data/information.

Cheers ...
Marek

-- 
You are receiving this mail because:
You are on the CC list for the bug.