Monday, April 30, 2012

Replace Test urls in Wordpress to live using phpmyadmin

Just a quick help snippet for those of us who test wp websites on a test domain before moving them to a live url.

This issue arises when using a test domain for building a site and uploaded images, pdfs etc link to the test domain. When you make the website live the links still point to the old url in each and every post and page. Here is a quick SQL snippet to replace those old urls.

    UPDATE wp_posts
    SET guid =
    REPLACE(

        guid,
        "http://TestDomain/",
        "http://www.LiveDomain.com/"

    );

 UPDATE wp_posts
    SET post_content =
    REPLACE(

        post_content,
        "http://TestDomain/",
        "http://www.LiveDomain.com/"

    ); 


update wp_options
set option_value =
replace(
       option_value,
       "http://TestDomain/",
        "http://www.LiveDomain.com/"
); 


Stumble Upon CodePyro

1 comment:

Benny said...

These days all of us reach check out the actual rolex replica sale the plunge watch which that's presently promoting with regard to $499. As the Anstead is actually officially the plunge replica watches sale, Personally i think it's a excellent just about all event watch regardless of whether within the sea, work, or simply your own replica watches. This really is officially the 2nd edition from the Oceanis, or even the actual development from the fake rolex sale. Numerous may keep in mind that design or even nevertheless personal 1, also it had been an excellent watch in a very economical cost which was financed rolex replica sale. For that 2nd edition, Jones transformed the actual bezel as well as overhead style with the addition of overhead pads, the somewhat domed rolex replica very, improved to some Miyota 9015 automated motion, as well as additional a good hyperlink stainless band along with rolex replica sale expansion hold. We can't evaluate both variations when i in no way noticed the very first design personally, however I will let you know this replica watches sale includes a great deal to provide particularly from it's present purchase cost associated with $499. The actual building domed very, smoothness from the crown/bezel, and the entire appear offers truly created the actual Oceanis a wrist watch that's difficult to consider from the arm.

Post a Comment