Possible to do a find and replace accross the entire forums?

[Dave-M]

I need to do something like a find and replace on the whole site.

We have been hosting our images on a separate domain so the forum didn't exceed it's bandwidth...

Anyway, we have moved servers and bandwidth isn't a problem, so I want to change all the links from www.images-mysite.com to www.mysite.com.

There are hundreds of images posted in hundreds of posts/threads, so going through them all and editing would take forever.

Is there a quick way of doing this?

Any help will be appreciated, thanks :)

Dave.

[Kinneas]

Your best bet would be a MySQL query to update any values in the post tables from the old one to the new one. I'm not sure exactly what query you'd need to run though.

[Paul M]

Variable replacements should do it I think.