From owner-freebsd-questions@FreeBSD.ORG  Tue Sep 18 13:49:40 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id EF0B416A417
	for <freebsd-questions@freebsd.org>;
	Tue, 18 Sep 2007 13:49:40 +0000 (UTC)
	(envelope-from fbsd.questions@rachie.is-a-geek.net)
Received: from snoogles.rachie.is-a-geek.net
	(66-230-99-27-cdsl-rb1.nwc.acsalaska.net [66.230.99.27])
	by mx1.freebsd.org (Postfix) with ESMTP id C9B9B13C442
	for <freebsd-questions@freebsd.org>;
	Tue, 18 Sep 2007 13:49:40 +0000 (UTC)
	(envelope-from fbsd.questions@rachie.is-a-geek.net)
Received: from localhost (localhost [127.0.0.1])
	by snoogles.rachie.is-a-geek.net (Postfix) with ESMTP id BA87B1CDEE
	for <freebsd-questions@freebsd.org>;
	Tue, 18 Sep 2007 05:49:28 -0800 (AKDT)
From: Mel <fbsd.questions@rachie.is-a-geek.net>
To: freebsd-questions@freebsd.org
Date: Tue, 18 Sep 2007 15:49:25 +0200
User-Agent: KMail/1.9.7
References: <8980.80.80.2.75.1190116887.squirrel@webmail1.one.com>
In-Reply-To: <8980.80.80.2.75.1190116887.squirrel@webmail1.one.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200709181549.27302.fbsd.questions@rachie.is-a-geek.net>
Subject: Re: Deleted /var/db/pkg
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 18 Sep 2007 13:49:41 -0000

On Tuesday 18 September 2007 14:01:27 nikolaj.thygesen@diamondbox.dk wrote:

>     Suppose you deleted /var/db/pkg by accident :( What would you do to
> get it back??

Depending how fast your disk and cpu is:

cd /usr/ports
find . -name pkg-plist -print|xargs egrep -H '^(s?bin|lib)' |while read MATCH;
do
        PATH=${MATCH##*:}
        if test -f /usr/local/${PATH}; then
                 echo ${MATCH%%/pkg-plist:*}
        fi
done | grep -v XFree86-4-*|sort -u >myports.lst

Then look carefully for mismatches and feed myports.lst to portinstall.
-- 
Mel