Date: Mon, 29 Nov 2021 11:22:01 +0000 From: Jamie Landeg-Jones <jamie@catflap.org> To: freebsd-current@FreeBSD.org, dclarke@blastwave.org Subject: Re: pkg sqlite database borked ( again ). How to restore? Message-ID: <202111291122.1ATBM1vp034286@donotpassgo.dyslexicfish.net> In-Reply-To: <4d9d5406-c257-e5cb-d237-d26889468f62@blastwave.org> References: <4d9d5406-c257-e5cb-d237-d26889468f62@blastwave.org>
next in thread | previous in thread | raw e-mail | index | archive | help
Dennis Clarke via freebsd-current <freebsd-current@FreeBSD.org> wrote: > europa# xz -dc /var/backups/pkg.sql.xz.3 > /var/db/pkg/local.sqlite.dump > > europa# > europa# pkg backup -r /var/db/pkg/local.sqlite.dump > Restoring database: > Restoring: 100% > pkg: sqlite error while executing backup step in file backup.c:98: not > an error The backup file consists of sql statements, the pkg backup -r I think requires a binary db file. I think you need to do this: pkg shell < /var/db/pkg/local.sqlite.dump Cheers, Jamie
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?202111291122.1ATBM1vp034286>