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

964 thoughts on “Migrating WordPress to a new URL”

  20. This piece of writing is truly a fastidious one it
    helps new the web people, who are wishing for blogging.

    Check out my homepage: Homepage

  24. is biggest online casinos – Michaela, gambling banned in australia, play pokies australia no money required and real money poker united states
    app, or bet365 new zealandn roulette tips

  38. united statesn online casinos real money, best casino united states online
    and canada offshore gambling, or big poker tournaments odds of getting 20 in blackjack – Patti – australia

  40. an canadian casino, usa roulette rules and online casino australia no deposit bonus codes, or montreal australia floating dragon casino skyfall
    - Leesa,

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>