Need to edit URLs in database

  • Resolved David Borrink

    (@davidborrink)


    16 years, 11 months 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!

Viewing 3 replies - 1 through 3 (of 3 total)
  • MichaelH

    (@michaelh)

    16 years, 11 months ago

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

    Of course, backup your database before attempting anything.

    Thread Starter David Borrink

    (@davidborrink)

    16 years, 11 months 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!

    sabinou

    (@sabinou)

    16 years, 5 months 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 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Need to edit URLs in database’ is closed to new replies.