View Single Post
Old 04-17-2011, 12:29 PM  
TheDoc
Too lazy to set a custom title
 
TheDoc's Avatar
 
Industry Role:
Join Date: Jul 2001
Location: Currently Incognito
Posts: 13,827
Quote:
Originally Posted by marktruman View Post
is that a command, where is that entered?
If you're unsure what that is, it's best to ask your host to run it for you.... just tell them exactly what you want found and replaced and most hosts will gladly do it for you.

Otherwise, enter php my admin, access the wp db, hit the post table, click the SQL tab at the top, and enter that line.... after you change out what to replace. Your wp_posts table may be named differently.

UPDATE wp_posts SET post_content = replace(post_content, "www.oldurl.com", "newurl.com");

Screwing this up though can really screw some shit up... the last tab at the top, whatever it is, will let you duplicate the post table & structure to a new table name - highly recommended doing this if you've never ran a command like this before.
__________________
~TheDoc - ICQ7765825
It's all disambiguation

Last edited by TheDoc; 04-17-2011 at 12:31 PM..
TheDoc is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote