From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by finch.gentoo.org (Postfix) with ESMTPS id 2DC89138330 for ; Thu, 11 Jan 2018 18:03:04 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id EED6AE091D; Thu, 11 Jan 2018 18:02:58 +0000 (UTC) Received: from mail-io0-x22b.google.com (mail-io0-x22b.google.com [IPv6:2607:f8b0:4001:c06::22b]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id AA043E0904 for ; Thu, 11 Jan 2018 18:02:58 +0000 (UTC) Received: by mail-io0-x22b.google.com with SMTP id 25so2894346ioj.9 for ; Thu, 11 Jan 2018 10:02:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=8OhIDUUBJucwU66aUQX3n9T/HTpYjftyXmXbafEg164=; b=CCyyH2CRDihdS1KtLKXBlo+whdpxuqNqBOroxN7rmALXaZhsHN34ZyHFYYguq9YDeT eIy6Yid7KDfUBgRfNwN3oQ88D34PIyfBtMomd+TEcAH1lIgn1063UkHBX7tjez6CddCh 5MN9JlneVFo8j3oMCkFYSknkW+lXCXOfucBs639aAQW94waathh+nqdXVC5sKvkBcIKU 5aPAhc/qjnlYVxYu/rYgK1qOtikhwfzu4ohNX465xH0TjNZrgHaQlirCU/90bF6aiaA3 uojBM9mmtwuIuOOhSXdjiyv40jB7kiye3QfhJW/JATRg4j6xY+cOEKs/KLxxZV3i7PQZ 6BfQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=8OhIDUUBJucwU66aUQX3n9T/HTpYjftyXmXbafEg164=; b=eJN3N0MWUnm8XEnYA3dC7uiQy0tQ0k2wrhyJXycSBKgSLQ16WL0gNyIocbFmB7eRFe a2sPh9SNogN+9/RxRGNScy71C/dmSB2UZZEN1GaIk2Yj85hAHLzO8dPRapnS/Y5RcCEB p55tQOEGqPC5niOk63R7gkxuTqOefNkoLYEr+kNvYn2VqdhzHC4+GxdazFETIsKBWfUQ OJRfH9nvv8cCFjlsj2thy1tzQF/XPdTa5eIH4lg5akqZM/tjfWTuyqhSTwNM45vZVRZ9 gr3H1Vs4QHYk6egypiirR48R82eBXYC2vNNUmcvSglvtd6895a+26XdjjuKWihm3X17B Rvig== X-Gm-Message-State: AKwxytcFYzGldyGJayBmfPQ106j9SIM6II+mUcjR0p1pJeLc5n/QMolb KTAAKYHMRg4zQptVjmGBCyoQZi0YEYb2bC+dznSmExyX X-Google-Smtp-Source: ACJfBos3CEIajMZNwtN9Y9CzMuKQgsKKyktoizxvNDQeQgRDh+hMcUvUbUlpazahmFaV0kBJqVptQVus2Kg964oUTmU= X-Received: by 10.107.201.149 with SMTP id z143mr23988623iof.145.1515693777332; Thu, 11 Jan 2018 10:02:57 -0800 (PST) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@lists.gentoo.org Reply-to: gentoo-dev@lists.gentoo.org MIME-Version: 1.0 Received: by 10.107.43.142 with HTTP; Thu, 11 Jan 2018 10:02:56 -0800 (PST) In-Reply-To: <20180111162743.GA6628@gengoff.grandmasfridge.local> References: <20180110183135.GD15225@martineau.grandmasfridge.local> <20180111162743.GA6628@gengoff.grandmasfridge.local> From: Francesco Riosa Date: Thu, 11 Jan 2018 19:02:56 +0100 Message-ID: Subject: Re: [gentoo-dev] News Item: GnuCash 2.7+ Breaking Change (v3) To: gentoo development Content-Type: multipart/alternative; boundary="94eb2c0b745e2fb00e056283f533" X-Archives-Salt: 6b9ea418-20fc-489e-b1eb-e493044a851e X-Archives-Hash: acb79c77f2325ec75b5f15fa8a57b854 --94eb2c0b745e2fb00e056283f533 Content-Type: text/plain; charset="UTF-8" 2018-01-11 17:27 GMT+01:00 Aaron W. Swenson : > This time with a version constrain that should allow this to expire at > some point in the future. > > Title: GnuCash 2.7+ Breaking Change > Author: Aaron W. Swenson > Posted: 2018-01-11 > Revision: 1 > News-Item-Format: 2.0 > Display-If-Installed: > Along with changes to use modern libraries, GnuCash 2.7+ has changed the > schema [1] it uses for both databases and files. GnuCash will > automatically modify the file or database in place upon open. > > Therefore, it is imperative that you back up any files or databases > before using GnuCash 2.7 in case you run into an issue and want or need > to revert back to 2.6. > > Instructions for backing up are as follows: > > For XML (plain files): > $ cp /path/to/file.gnucash /path/to/file.gnucash.bak > > For MySQL: > $ mysqldump gnucash_db | mysql gnucash_db_bak > > For PostgreSQL: > $ createdb -U dbadmin -T gnucash_db -O gnucash_user gnucash_db_bak > > For SQLite: > $ cp /path/to/gnucash/sqlite.file.gnucash /path/to/gnucash/sqlite.file. > gnucash.bak > > [1] https://github.com/Gnucash/gnucash/releases/tag/2.7.0a > It could be wise to close GnuCash before backup, also the choice of creating a copy of the database is a bit unusual, an offline backup may be more appropriated, example for mysql: mysqldump gnucash_db | xz > gnucash-2.6.sql.xz It's ok to leave restore instruction out, since those are usually easy to find and spending more time with it does not hurt --94eb2c0b745e2fb00e056283f533 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


2018-01-11 17:27 GMT+01:00 Aaron W. Swenson <titanofold@gentoo.org= >:
This = time with a version constrain that should allow this to expire at
some point in the future.

Title: GnuCash 2.7+ Breaking Change
Author: Aaron W. Swenson <titan= ofold@gentoo.org>
Posted: 2018-01-11
Revision: 1
News-Item-Format: 2.0
Display-If-Installed: <app-office/gnucash-4

Along with changes to use modern libraries, GnuCash 2.7+ has changed the schema [1] it uses for both databases and files. GnuCash will
automatically modify the file or database in place upon open.

Therefore, it is imperative that you back up any files or databases
before using GnuCash 2.7 in case you run into an issue and want or need
to revert back to 2.6.

Instructions for backing up are as follows:

For XML (plain files):
$ cp /path/to/file.gnucash /path/to/file.gnucash.bak

For MySQL:
$ mysqldump gnucash_db | mysql gnucash_db_bak

For PostgreSQL:
$ createdb -U dbadmin -T gnucash_db -O gnucash_user gnucash_db_bak

For SQLite:
$ cp /path/to/gnucash/sqlite.file.gnucash /path/to/gnucash/sqlite.file= .gnucash.bak

[1] https://github.com/Gnucash/gnucash/r= eleases/tag/2.7.0a

It could be wise to= close GnuCash before backup, also the choice of creating a copy of the dat= abase is a bit unusual, an offline backup may be more appropriated, example= for mysql:
mysqldump gnucash_db | xz > gnucash-2.6.sql.xz

It&= #39;s ok to leave restore instruction out, since those are usually easy to = find and spending more time with it does not hurt


--94eb2c0b745e2fb00e056283f533--