On Jun 18, 2020, at 4:25 PM, Mark Dadgar <mark@pdc-racing.net> wrote:
Any thoughts on how to salvage ~20 years of list archives?
The archives shouldn't be an issue. I don't think they are involved in the corruption, but anyway, hopefully you still have the archive mbox you imported. Then for the messages since then, you should be able to get a mbox from hyperkitty with something like
with the obvious substitutions and appropriate start and end dates.
The list is trickier. If you are going to start over with a clean install, and if you have a config.pck that you imported from MM 2.1, I suggest the following:
Use the
mailman memberscommand to get a list of all members. Then depending on how much work you want to do, also get separate lists of plaintext and mime digest members and members with delivery disabled.Then on the new install, import the config.pck with
mailman import21and import the archive mboxes with hyperkitty_import.Run
mailman members --syncwith the full current membership list, and record the [ADD]s. Then you can match the [ADD]s against the plain and mime digest members and those with delivery disabled and set their options.That's a lot to do, but it should get you close.
I would probably be satisfied with just exporting the current list of member email addresses + names and letting people go back and change their list settings to switch to digest, etc. if necessary.
On the other hand, if you can wait, we might be able to figure out how to fix this, and it's even possible the underlying issue isn't database corruption.
Sure - I can wait. Thank you.
I am probably going to go ahead with the list wipe and recreate in the next couple of days. Lack of access to the administration stuff is starting to become a problem.
Sigh.
So far, migrating from sqlite3 to postgres is looking like a bit of a bust.
- Mark
mark@pdc-racing.net | 408-348-2878