The mailing list for listmasters using Sympa

[Nick Holden <address@concealed>]

How obvious things like this are, once someone else has done the work
for me! That worked a treat. 111 users are not getting their list email
again.

Thanks very much,

Nick

On Sat, 2004-12-04 at 09:40, Rudolf Weeber wrote:
> Hi,
> On Sat, Dec 04, 2004 at 08:48:01AM +0000, Nick Holden wrote:
> > Hi all,
> > 
> > I've just been contacted by a subscriber to one of my lists who says
> > that their IPS (onetel.net.uk) have changed over all their email
> > customers to new addresses - same user name but at onetel.com instead.
> [...]
> > Aside from complaining to Onetel about this very abrupt denial of
> > service to their customers, I need a way to alter the sympa database
> > table to search for one mail domain and replace with another without
> > changing the local part of the email addresses - i.e. a bulk select and
> > replace.
> > 
> > Has anyone written such a script? Or is there an easy way to do this in
> > MySQL that I don't know about?
> We had the saem problem at the university. A friend of mine sent me the
> following sql-statement. I didn't try it, su use it on your own risk :-)
> 
> UPDATE <NameOfTheTable> SET email=REPLACE(email, 
> '@studbox.uni-stuttgart.de',
> '@stud.uni-stuttgart.de');
> 
> 
> 
> And do backup your database first :-)
> 
> Yours, Rudolf
> 
>