Migrating WordPress to a new URL

Posted on by

WordPress is a nonsense, and stores it’s URL in multiple places in the database. If you want to move your WordPress install to a different host, exec the following MySQL commands to change the URL in all instances:

UPDATE wp_options 
   SET option_value = REPLACE(option_value, "[Old site URL]", "[New site URL]")
 WHERE option_value LIKE "%[Old site URL]%";
 
 UPDATE wp_posts 
   SET post_content = REPLACE(post_content, "[Old site URL]", "[New site URL]")
 WHERE post_content LIKE "%[Old site URL]%";
 
  UPDATE wp_posts 
   SET guid = REPLACE(guid, "[Old site URL]", "[New site URL]")
 WHERE guid LIKE "%[Old site URL]%";

   UPDATE wp_postmeta
   SET meta_value = REPLACE(meta_value, "[Old site URL]", "[New site URL]")
 WHERE meta_value LIKE "%[Old site URL]%";

Replace [Old site URL] and [New site URL] appropriately

Use this form to generate the SQL for YOUR database

5,382 thoughts on “Migrating WordPress to a new URL”

  11. real money casino usa online, united statesn roulette best odds and free slots that pay real money usa,
    or best japanese online casino dealer (Jerilyn) pokies new zealand
    casino

  16. gaming club casino usa login, best casinos in south united states and best rated united states online casino, or new zealand star casino

    Also visit my web site – baccarat betting strategy forum, Essie,

  19. new zealandn no deposit bonus casinos, best online casino south united states
    and no deposit bonus uk poker, or best australia casino pier
    rides (Dulcie) app

  21. top 10 usa casinos, is online gambling allowed in australia and crown casino online blackjack
    (Joel) kingdom usa, or online blackjack canada paypal

  26. best online poker tournaments uk, best australian online casinos and 200 free spins no
    deposit canada, or casino age limit canada

    Also visit my web site win coin gambling (Niki)

  44. I’m really impressed along with your writing skills as smartly as with the structure in your blog. Is that this a paid subject matter or did you modify it yourself? Either way stay up the nice high quality writing, it?s uncommon to see a nice weblog like this one nowadays..

  46. Hi I am so grateful I found your blog, I really found you by mistake, while I was researching on Google for something else, Anyways I am here now and would just like to say many thanks for a incredible post and a all round exciting blog (I also love the theme/design), I don’t have time to read it all at the moment but I have book-marked it and also added your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the excellent work.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>