Updating All Internal Links in a WordPress Blog
Post Info Saturday, July 11th, 2009 5:45 pm by Cody Print Print this page

Suppose you are switching domains and you want all links to point to your new blog.  There are 3 places where you need modifications: the author comment URL, the comment content, and the post content.  Comments are important as people may refer to your blog in the comments section, so it needs to be updated.

Perform the following queries:

UPDATE wp_comments SET comment_author_url = replace(comment_author_url, 'old URL','new URL')
UPDATE wp_comments SET comment_content = replace(comment_content, 'old URL','new URL');
UPDATE wp_posts SET post_content = replace(post_content, 'old URL', 'new URL');

Reference: How to Move WordPress Blog to New Domain or Location

9 Responses to “ Updating All Internal Links in a WordPress Blog ”

  1. Derosa

    Skoro eto sluchitsya

  2. Nga

    rano ne pozdno

  3. Ferasa

    press releases

  4. Nga

    vim to very

  5. jorg

    At last it happens!

  6. Sasha

    Excellent news

  7. ????? ???? ?????

    ???????????? ?????? ???? ??????.

  8. ????????? ?????

    ????? ? ?? ????????, ?? ????? ?? ???? ?? ??????? ???????!

  9. ROLAND


    MedicamentSpot.com. Canadian Health&Care.No prescription online pharmacy.Special Internet Prices.Best quality drugs. High quality drugs. Order drugs online

    Buy:Lipitor.Female Cialis.Cozaar.Seroquel.Lipothin.Benicar.Prozac.SleepWell.Buspar.Amoxicillin.Female Pink Viagra.Advair.Ventolin.Zetia.Aricept.Nymphomax.Wellbutrin SR.Zocor.Acomplia.Lasix….

Leave a Reply

Get updates as often as we post! Subscribe to our full feed or comments feed.