Run this SQL query:
[sql]UPDATE post SET pagetext = REPLACE(pagetext,'www.olddomain.com','www.newdomai n.com')[/sql]
For pm's this SQL query:
[sql]UPDATE pmtext SET message = REPLACE(message,'www.olddomain.com','www.newdomain .com')[/sql]
Note that query is very intensive, you should back-up your db before using it. It may very well screw up a lot of your posts/pms/entire database.
Remember to re-build the postcache if you use it, or the changes will not apper right away.
|