HOW TO Restore a PKG db in FreeBSD 12 # cp /var/backups/pkg.sql.xz /tmp # unxz /tmp/pkg.sql.xz # cat /tmp/pkg.sql | sqlite3 /var/db/pkg/local.sqlite