From nobody Fri Feb 24 21:20:57 2023 X-Original-To: ports-bugs@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4PNjVd4cQNz3txNV for ; Fri, 24 Feb 2023 21:20:57 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4PNjVd2klCz3x1k for ; Fri, 24 Feb 2023 21:20:57 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1677273657; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=4g65t/LyV5CucNvb53EcjjmJQH1GbXizmdHP6eXqbEY=; b=ilVeH2JKZfNCs29J1IWxtdo1rdKZBVRBt/+oAgO1ArtfhLz3L9vJoEKbsrgtNSXgChkAna hoIfKlSjIr0mvl7+BzklWPeOYclYA7sKpjljE9g6WiEY3UWxBZc8k5b8c4tqaLhb3dc2HI uvVfTqUgnyFoAjqez4QHL3ciFjR2VpdyyyGsEHWDONoZ4Ep6Iinsr30EE9IprWko+CIXym edz3m+ytZCiNEUptrPbeHnSACBPlIYU4O0VFVTxH+2985lsQA3gx/LxP86O21nhdtmDmLb 2oyxD6MKFvGuRfUD+D7FA0zMi8DnAWR8zRYQQOkxbUDzctb38ezkzeo2xStTcQ== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1677273657; a=rsa-sha256; cv=none; b=Dc2mOJef6+GJ0ZKv5ha7hTVqjI9Kkf7Mlp57s6DtoFFRzwgq1x3DJS1fFwLlDg6p2GlDmN ASOFV40OY+FNdEF1+mfK65OUSQEPpoglzS0FlbfMdl0arY16IT1cBFZVHbFdYaiFcLAo2W w5Xye/iFmy8LM75eIaNjv/nrW8Xq7xda8uObfY+qL17Ie0QPybqbpzyuKpp/ktDPyB0Dwn n/OnbZQgllf99HUwQUkd2RGaI6tPWQ5szItcdgu3jvk+Yb/H9QICnxstDskliT5krCHjdw dptd8I+YhhYVbiDcpE4hjoPX3IhosdVNJwzleoF3LtugmYyBdF0SwaKnT4j+aQ== Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4PNjVd1pdLzdkQ for ; Fri, 24 Feb 2023 21:20:57 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 31OLKvrP068806 for ; Fri, 24 Feb 2023 21:20:57 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 31OLKvgl068805 for ports-bugs@FreeBSD.org; Fri, 24 Feb 2023 21:20:57 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 269810] How to restore pkg database Date: Fri, 24 Feb 2023 21:20:57 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: mfv@bway.net X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: ports-bugs@FreeBSD.org X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports-bugs@freebsd.org X-BeenThere: freebsd-ports-bugs@freebsd.org MIME-Version: 1.0 X-ThisMailContainsUnwantedMimeParts: N https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D269810 Bug ID: 269810 Summary: How to restore pkg database Product: Ports & Packages Version: Latest Hardware: amd64 OS: Any Status: New Severity: Affects Many People Priority: --- Component: Individual Port(s) Assignee: ports-bugs@FreeBSD.org Reporter: mfv@bway.net Now that 'pkg backup' has been removed I do not know how to restore a corru= pted pkg database. The FreeBSD manual at section '4.4.11. Restoring the Package Database' shows 2 methods. The 1st methid is the now-removed 'pkg backup -= r' while the 2nd method is implied by the use of the compressed file created by 'periodic daily', that is, a compressed version of a sqlite3 dump. However there are no instructions how to create/restore a new database from= the file created by 'periodic daily'. I have uncompressed pkg.sql.xz and then = read pkg.sql into a news database using sqlite3 but the new database is much sma= ller than the original database, local.sqlite. In summary what are the manual commands to create/restore a new pkg database from 'periodic daily'. Alternatively, would there be any harm to just manu= ally make backup copies of local.sqlite, say as local.sqlite.1, local.sqlite.2, = etc. With thanks, Marek --=20 You are receiving this mail because: You are the assignee for the bug.=