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,315 thoughts on “Migrating WordPress to a new URL”

  18. how do poker machines work in australia, casino offers
    no deposit usa and new zealand real money casino, or $5 deposit pokies canada

    Feel free to surf to my web site harrah’s cherokee gambling (Hans)

  23. bonanza slot volatility, fast payout casino nz and no
    deposit poker bonus usa 2021, or no deposit bonus
    casino microgaming australia

    Here is my web blog; double street roulette (Alissa)

  31. free signup bonus no deposit mobile casino uk 2021, real usa
    online casino and united kingdom friendly online poker sites, or free 10
    no deposit how big is thunder valley casino (Hilda) uk

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>