Changing domain name, what to do with all the links inside the forum?

[Schnee]

Hi there,

We are considering changing our domain name, but throughout the forum, we have thousands of links to the old domain when users post links to point to where they wanted someone else to read.

Is there a way to globally change all instances of domainabc.com to domainxyz.com in the entire forum? Probably a sql query and probably dangerous, but ...

how do people do this?

Thanks!

[dodgeboard.com]

You can do it with a 301 redirect.

See this: http://www.vbseo.com/f2/changing-dom...taccess-27465/

[Lats]

Backup first...

UPDATE 
    post
SET 
    pagetext = replace(pagetext,'domainabc.com', 'domainxyz.com') 
WHERE 
    pagetext LIKE '%domainabc.com%'