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

621 thoughts on “Migrating WordPress to a new URL”

  1. is gambling allowed in united states, gambling in ontario australia and can you make a living from online blackjack (Lashonda) gambling united states poker, or is top online pokies and casinos united
    states pokies

  2. united kingdom gambling online, usa new online casino and online slots australia ipad, or united statesn gambling regulations

    Here is my web-site – craps minimum bets vegas, Minerva,

  13. canadian online pokies no minimum deposit, online casino
    uk reviews and online casino canada, or no deposit casino usa

    Here is my blog – how can i control my gambling (Alisa)

  16. casino online usa all sites, free spins australia and
    casino bonus usa, or no deposit bonus aus casino

    Feel free to surf to my web page :: casinos in the desert area – Darwin
    -

  18. top online pokies and casinos united states information,
    free bonus no deposit casino usa 2021 and dollar 5 deposit
    online casino australia, or new casino slots uk

    my homepage – expected value craps [Joni]

  26. online poker that takes united statesn express, difference between european roulette and united kingdom and
    most reliable online Bbd Casino australia, or best online casinos united states 2021

  37. best online pokies united states casino, spin casino nz login and top
    online pokies and casinos australian open,
    or casinos in toronto united kingdom

    Also visit my page :: gambling account mortgage (Latoya)

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>