Forums

[resolved] Need to edit URLs in database (4 posts)

  1. David Borrink
    Member
    Posted 2 years ago #

    Just created a redesign in a dev folder on my client's site. I'll call it dev.domainname.com. I followed the instructions on the codex for moving a site within a domain but the instruction to change permalinks didn't give me the option to do so in 2.7.1. The site is working in the domainname.com, but I have a problem:

    All the images are linking to the uploads folder on dev.domainname.com, but I need to have them find the moved uploads folder on domainname.com, it's a duplicate.

    All the posts have the image URLs as dev.domainname.com. I don't want to go into all the posts and change the URLs manually. I want to go into PHPMyAdmin and do this. Can anyone give me a few tips as to what table contains the post contents, and how to I do a search and replace of it? I can get to the wp_posts table and see some editing options, but I just don't want to screw this up.

    How do I change "dev.domainname" to just "domainname" in a search and replace without messing up the database?

    Thanks!

  2. MichaelH
    Volunteer
    Posted 2 years ago #

    Look at this plugin:
    http://wordpress.org/extend/plugins/search-and-replace/

    Of course, backup your database before attempting anything.

  3. David Borrink
    Member
    Posted 2 years ago #

    SUPER! That was exactly what I needed. And sooooo much easier than trying to use PHPMyAdmin.

    I had 582 instances that were edited. And it finished in a snap. Love it. Thank you!

  4. sabinou
    Member
    Posted 2 years ago #

    Yep, thanks a lot, this plugin was a saviour. Until now I used to do it with a short script found at Lorelle's wordpress-related blog, with phpmyadmin, but moving the worpdress-CMS-Eshop powerplant of a friend to a new host with a different public URL was a living hell... until I read the recommendation to use that plugin :)

    Thanks a lot :)

Topic Closed

This topic has been closed to new replies.

About this Topic