Mailing-List: contact dev-help@openoffice.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openoffice.apache.org
From: Chris Lambertus <cml@apache.org>
Message-Id: <E1AC177F-CFB6-42B6-92BB-3188C28391F1@apache.org>
Content-Type: multipart/signed;
 boundary="Apple-Mail=_A08C4558-2C7B-4090-8969-B689F3EE8832";
 protocol="application/pgp-signature"; micalg=pgp-sha512
Mime-Version: 1.0 (Mac OS X Mail 10.3 \(3273\))
Subject: Re: Hu Forum woes
Date: Wed, 9 Aug 2017 16:01:49 -0700
In-Reply-To: <e4dbca79-e858-74e4-56ba-c15d6db5ffa6@apache.org>
Cc: dev@openoffice.apache.org,
 users@infra.apache.org
To: Andrea Pescetti <pescetti@apache.org>
References: <5a8132a3-771b-1aa0-4472-376bcdbfd17b@hdsnet.hu>
 <e4dbca79-e858-74e4-56ba-c15d6db5ffa6@apache.org>
archived-at: Wed, 09 Aug 2017 23:01:54 -0000

--Apple-Mail=_A08C4558-2C7B-4090-8969-B689F3EE8832
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8


> On Aug 9, 2017, at 3:35 PM, Andrea Pescetti <pescetti@apache.org> =
wrote:
>=20
> On 08/08/2017 Reizinger Zolt=C3=A1n wrote:
>> I as admin of Hungarian Forum deleted nearly all post in Hungarian
>> forum, during maintenance.
>> Can anybody restore the forum database to yesterday status?
>=20
> Database backups for https://forum.openoffice.org/ are managed by =
Infra, since we use a shared cluster. CCing the Infra list. I assume we =
will coordinate through a JIRA ticket to restore the status of the =
database at the last backup we had when the incident happened (can you =
be more precise about date and time?), but at least Infra is informed =
that those backups must be kept.
>=20
> An important note: if I recall correctly, we have several forum =
installations (one per language) sharing the same database. Please let's =
coordinate, since restoring the old database is not a solution (it would =
restore the Hungarian forum but also delete recent activity from all =
other forums). I think we will need to only filter tables with a certain =
prefix.


Infra would need to know exactly what point in time this occurred (UTC) =
and what objects would need to be restored. There is a forumooo_hu =
database which is the likely target for restoration. Please include =
those details in an infra Jira ticket.

-Chris


--Apple-Mail=_A08C4558-2C7B-4090-8969-B689F3EE8832
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename=signature.asc
Content-Type: application/pgp-signature;
	name=signature.asc
Content-Description: Message signed with OpenPGP

-----BEGIN PGP SIGNATURE-----
Comment: GPGTools - https://gpgtools.org

iQEcBAEBCgAGBQJZi5RdAAoJEOqQjp5olQuT4uwH/A/4xkbVLPdy0vb5zTlqlPBI
8LhBbYnUcfPe6ZD9NTv8fcPTy891P4LGxoibvbZcwsSsXCzKiQWj8UCM7CvXI37S
iz5fMAX2HIOhITjCYCfIiuB/ouwOQxREC8N1EFnUbctb3zj0aDqRGnE0pgpGJ8AB
ziSP4Jv+kkH2WwGhAGU9sxkMicfl2FzMV76OoAF80AmdtIVemQAKEW8TN2d3Ofcr
8E3fSXRhdzXafk1UnEDNE68/TyxYGF1/KP9aoSaGS3StrYMtW24LnUb8CC5CRAP2
UdytlcZCi5Qi3szbcntGV4nVCAKeSW6nwtGcanZ7ZM04c8/Cb6Pe8cAO4RRe1r0=
=ocLO
-----END PGP SIGNATURE-----

--Apple-Mail=_A08C4558-2C7B-4090-8969-B689F3EE8832--