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

  18. I’m blown away by the quality of this content! The author has undoubtedly put a great amount of effort into exploring and arranging the information. It’s refreshing to come across an article that not only offers valuable information but also keeps the readers engaged from start to finish. Kudos to her for making such a brilliant work!

  23. I do not even know how I stopped up right here, but I assumed this post was good.
    I do not understand who you are however definitely you’re going to a well-known blogger
    for those who aren’t already. Cheers!

    Feel free to surf to my web-site :: best betting App Uk

  34. free pokie spins australia, western australian poker league and odds of
    winning pokies united states, or best usa online slot sites

    Feel free to surf to my web page … tips to playing roulette
    at a casino; Josefina,

  40. top 10 online casinos in canada, rules of gambling usa and new gambling
    legislation united states, or online poker with united statesn funds

    my page: casino winning formula [Winfred]

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>