On Mon, Nov 20, 2023 at 12:14 PM Stephen J. Turnbull < turnbull.stephen.fw@u.tsukuba.ac.jp> wrote:
Odhiambo Washington writes:
I use the utf8mb4 character set as default, unless something wants a different one. MySQL and MariaDB are almost similar. I have encountered very few significant differences since I switched to MariaDB.
OK, then that would not be a problem.
On Mon, Nov 20, 2023 at 7:56?AM Stephen J. Turnbull < turnbull.stephen.fw@u.tsukuba.ac.jp> wrote:
Isn't one installation using 'mailman' and 'mailmanweb' databases, while the other only 'mailman'? You'll need to deal with that at least I suppose.
This is true. However, I was hoping that I could merge the two foreign DBs into one. I am yet to test it though.
Yes. The point is that when you dump 'mailman' and 'mailmanweb' on the old host the name of the database will occur in at least the SQL CREATE DATABASE and CONNECT commands. You will need to edit that for mailmanweb.
Actually, that was the easier part.
[snip]
If there are only a few, it's little more time spent than writing scripts. And you can be sure you'll have basically working lists that you can fix any inadvertant configuration changes later. The only thing I would double and triple check is privacy settings (reply-to munging, archives, and subscriber rosters) and DMARC settings. In the MTA of course you want to be very careful about getting SPF and DKIM right for the new domain.
This is another easy part.
How do I dump the archives into an mbox file?
Thanks for all the support.
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]