I noticed that all my images on the posts here weren’t showing and it was because the url to their location was still pointing at the sub blog on The Comluv Network so I needed a way to edit the database to update the url to point to the files held here.
Easy with a REPLACE function on the wp_posts table.
You just need 3 things for the replace command :
- The row you’re altering
- The string you’re searching for
- The string you’re replacing with
UPDATE `wp_posts` SET `post_content` = REPLACE( `post_content` , "fiddyp.comluv.com/files/", "fiddyp.co.uk/wp-content/uploads/" )
It did the whole table of posts in less than a second. Sweet, now all my images are back to normal on this site.
24.10.09 3:05 pm
Twitter: psychicgeek
#1I’ll be bookmarking this, thanks!
witchypoo´s last blog ..Bust A Move
24.10.09 10:30 pm
Very useful, its in my bookmarks now! By the way, nicely designed website.
#2Kalvster´s last blog ..Free Ubuntu VPN with HotSpot Shield (My Attempt)
26.10.09 5:17 pm
Hey buddy, sorry this is so OT. My apologies for being gone so long but my current post describes it a bit.
I’m ready now to re-subscribe and get back into your awesome blog! Slowly at first until I get full swing again.
#3Dennis Edell´s last blog ..What I’m Doing – What You Should Expect In The Very Near Future.
26.10.09 5:18 pm
Did you remove subscribe to comments, or is it automatic now?
#4Dennis Edell´s last blog ..What I’m Doing – What You Should Expect In The Very Near Future.