Quote:
Originally Posted by Brad.loo
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.
|
Posts and PMs Changed properly Thanks
Can you also list some more queries to change Signatures too
Changing homepage set under profile, and text content in the signatures