My company recently changed it's domain name. How would I change all the users email addresses to reflect the change?
There are a number of ways to do this.
Tell users to update their emails [probably not a good idea].
go into the ui and change each one manually [very time consuming depending on how many users you have].
interact with the users email addresses directly in the database. [This can be dangerous, so make sure that you always take a backup of your database prior to running any custom scripts or commands against it.]
A command like this might work: UPDATE ost_user_email SET address=REPLACE(address,'olddomain.org','newdomain.com');
UPDATE ost_user_email SET address=REPLACE(address,'olddomain.org','newdomain.com');
This SHOULD replace all instances of olddomain.org with newdomain.com. Again make sure that you take a database backup prior to running scripts and commands directly against your DB.
You could also write a custom script in your language of choice that iterates through all the users and changes their email address.
The "update" command worked great. Thanks!
Great glad to be able to assist.
I'll close this thread and mark it as resolved. Please start a new thread if you have another question, comment, etc.
