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

  3. I would like to thank you for the efforts you’ve put in writing this blog. I am hoping the same high-grade site post from you in the upcoming also. In fact your creative writing skills has inspired me to get my own site now. Actually the blogging is spreading its wings fast. Your write up is a great example of it.

  6. I have noticed that car insurance providers know the vehicles which are susceptible to accidents and various risks. Additionally, these people know what kind of cars are inclined to higher risk as well as higher risk they have got the higher your premium amount. Understanding the uncomplicated basics of car insurance will assist you to choose the right types of insurance policy that could take care of your family needs in case you get involved in any accident. Thank you for sharing your ideas in your blog.

  34. canada visa slots, pokies meaning australia and real money poker united states app, or free sign super
    double up keno game free download (James) bonus united statesn casino

  43. chusachansi casino in fresno california, free spins no deposit casinos canada
    and no deposit casino offers usa, or free united statesn slot machine games

    My page wsop real money nj; Jared,

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>