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

  21. big pokie wins australia 2021, best paying online pokies united kingdom
    and best payout gambling sites usa, or free play online pickham casino prizes (Lakeisha)
    canada

  35. It’s a pity you don’t have a donate button! I’d definitely donate to this excellent blog! I suppose for now i’ll settle for book-marking and adding your RSS feed to my Google account. I look forward to new updates and will talk about this site with my Facebook group. Talk soon!

  38. One more thing. I think that there are lots of travel insurance web sites of dependable companies that allow you enter your vacation details and acquire you the quotes. You can also purchase the particular international travel insurance policy on the web by using your credit card. All you have to do is to enter your current travel details and you can start to see the plans side-by-side. Just find the package that suits your budget and needs and then use your bank credit card to buy the item. Travel insurance on the internet is a good way to begin looking for a reputable company pertaining to international travel cover. Thanks for sharing your ideas.

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>