Redmine

For email:

UPDATE email_addresses SET `address` = REPLACE(address, 'old.domain', 'new.domain') WHERE `address` LIKE '%old.domain%'

UPDATE users SET `login` = REPLACE(login, 'old.domain', 'new.domain') WHERE `login` LIKE '%old.domain%'

Thankyou, I will try that!

Note: in preparation I looked at the database layout and the "email_address" table should be "users" too, also the "address" column should be "mail". Lastly, AFAIK Postgresql doesn't like backticks, so will omit those.

Maybe database schema has been changed from version to version. I've just gave you idea.

Thanks, it helped me on the way, I noted the current schema for others :)