Sorry Malcom, changed email client recently and it's a quite a battle still.
Exporting from the forums allegedly requires taking down the DB I certaintly DO NOT want to have the forums taken down at any point. I am not a MySQL guy but in my book `mysqldump` tries to dump without blocking. If that's not enought I am quite confident they are other ways to export in a non-blocking way. More knowledgeable folks reading this are warmly invited to confirm or infirm.
What metrics am I after? I can't be more specific than I've been already. We'll be doing data analysis with ELK so we need not more and not less than I've characterized. The goal is to identify patterns in issues and pain points after performing full-text analysis.
Have a pleasant afternoon, Adrien Le mardi 8 décembre 2020, 15:41:00 CET Malcolm a écrit :
On Tue, 8 Dec 2020 15:08:49 +0100 Adrien Glauser <adrien.glauser@gmail.com> wrote:
Hey Malcom, thanks for your quick reply,
Added heroes to addressees to my reply (this message).
We are looking for: - the full contents of - all posts (original posts + replies) - thread titles (unless it's already included in original posts) - of the [2017-1-1, 2020-12-7] (Dec 12 of this month) period. - exported to json
Somewhat doable?
Hi Adrien Please keep the forum-admin group in the reply, there are two other Admins to keep in the conversation.
My only concern would be having to take the forums offline for such a data dump.
But again, are there some specific metrics your after? Seems to me a crafted sql query would also reduce the data amount?
@Jim & Gertjan any other thoughts or concerns?