Skip to Content.
Sympa Menu

en - Re: [sympa-users] Mass replace email addresses

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Colas Nahaboo <address@concealed>
  • To: Dick Visser <address@concealed>
  • Cc: "address@concealed" <address@concealed>
  • Subject: Re: [sympa-users] Mass replace email addresses
  • Date: Mon, 27 Jul 2020 16:16:25 +0200

When I had to do it, I opted for a simple approach:
I did:
  • a global command line search / replace (sed...) in the config files,
  • I dumped the mysql database in text form (mysqldump --opt --skip-extended-insert  --skip-dump-date)
  • I replaced the emails in the dump with the same commands as for the config files
  • I reloaded the modified dump
Note that will not change the emails in the archives.
Using search/replace in text files makes checking and debugging easier in my opinion.

Colas.

On Mon, 27 Jul 2020 at 12:41, Dick Visser <address@concealed> wrote:
Hi

I'm looking for a way to do a mass search/replace of mail addresses in Sympa.
We have a large number of mail addresses that need changing, most of
them subscribers to lists, but also a number of owners.

thx!

--
Dick Visser
Trust & Identity Service Operations Manager
GÉANT


--
Colas Nahaboo - http://colas.nahaboo.net



Archive powered by MHonArc 2.6.19+.

Top of Page