On 6/18/20 3:33 PM, Mark Dadgar 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 members command 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 import21
and import the archive mboxes with hyperkitty_import.
Run mailman members --sync with 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.
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.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan