OK. I ran into a recent problem with pkg(8). Where it corrupted it's sqlite3(1) database of the locally installed ports /var/db/pkg/local.sqlite. I am aware of the option in pkg(8) to (re)create the database from a backup,
But given that pkg(8) itself borked the database, and that I need to know I can reliably recreate the database, if/when pkg(8) can't/won't. I was wondering if anyone might know the incantation for doing it with sqlite3(1).
I've already learned MySQL, and PostgreSQL. But sqlite(1) is quite a bit different.
Thank you for all your time, and consideration.
--Chris
pkg backup -r /path/to/db/backup
.But given that pkg(8) itself borked the database, and that I need to know I can reliably recreate the database, if/when pkg(8) can't/won't. I was wondering if anyone might know the incantation for doing it with sqlite3(1).
I've already learned MySQL, and PostgreSQL. But sqlite(1) is quite a bit different.
Thank you for all your time, and consideration.
--Chris
Last edited: