On 5/16/23 08:49, Dave Hall via Mailman-users wrote:
What I would really like to do is to drop all of the previous archives and start fresh. Looking at the table list for the database, It would appear that all of the archive content is stored in the tables with names that start with 'hyperkitty_' I'm wondering if I could just wipe the content of these tables, or exclude them from a backup, and then start fresh.
It is correct that all the HyperKitty tables start with hyperkitty_. I
*think* it would be safe to just drop the content of these tables, but I
won't guarantee that there aren't django_mailman3_ tables with foreign
keys into the hyperkitty tables.
As a superuser logged in to hyperkitty, you should see a Delete Archive button at the top level overview for a list. It would be safer to delete the archives that way.
Alternatively, if I restore the exiting archives to the new database with the correct unicode settings, could I re-run the hyperkitty-import tool and get it to pick up all of the messages it skipped due to the unicode problem?
This will work too. You will need to specify the --since option to
hyperkitty_import because the default for since is the date of the
newest message in the archive. The import will not reimport a message
whose Message-ID: is already in the archive.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan