On 4/17/20 10:23 PM, Andrew Bernard wrote:
Where are the posts stored in the database? What tables? How would on go about exporting them into mbox format for the complete set?
It depends on which archiver(s) if any are enabled for the list.
For the prototype archiver, messages are archived in Maildir format, <https://en.wikipedia.org/wiki/Maildir>, in the directory var/archives/prototype/<list-address>/
For Hyperkitty, messages are stored in the database in the hyperkitty_email table and non-plain text parts are in the hyperkitty_attachment table, but you don't need to know that because in any HyperKitty view, i.e. a message view, a thread view, a threads by month view ot an all threads view, there is a button to download all the messages in that view as a gzipped .mbox file.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan