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

  33. I do enjoy the manner in which you have presented this challenge and it does give us some fodder for consideration. Nevertheless, because of everything that I have seen, I simply hope as the comments pack on that people continue to be on issue and don’t embark on a tirade involving some other news of the day. Yet, thank you for this fantastic piece and although I can not really concur with this in totality, I respect the viewpoint.

  34. online casino usa bonus, united kingdom gambling revenue
    and online gambling canada banned, or united kingdom poker slots free

    My blog :: blackjack hole card game – Denice -

  35. There are actually a whole lot of particulars like that to take into consideration. That may be a nice level to deliver up. I provide the thoughts above as general inspiration but clearly there are questions just like the one you bring up where crucial thing might be working in honest good faith. I don?t know if greatest practices have emerged round things like that, however I’m certain that your job is clearly recognized as a good game. Each boys and girls feel the affect of only a moment?s pleasure, for the rest of their lives.

  36. united statesn legit online games to win real money (Janina) casinos real money, slot machines united states for sale and rules of roulette uk,
    or casino uk paypal

  38. best new zealand casino, australia slot machine games
    and new zealandn casino no deposit bonus codes, or cash
    bingo australia

    Also visit my site is crypto considered gambling (Floy)

  43. 888 poker deposit united kingdom, $10 deposit bonus casino nz and omni slots united states, or latest free spins no registration casino ideal;
    Derrick,
    deposit usa

  47. united statesn casino no deposit free spins, online casinos coupon codes; Cleveland, slots bonausaa and australian free pokies games,
    or most legit online casino united states

  49. free casino cash no deposit usa, free real online pokies united
    states and best casinos australia online, or free money online casino united kingdom

    Take a look at my web site; fivem blackjack exploit (Allie)

  50. gambling online in usa, best non usa casino sites and instant
    payout immortal romance casino game – Alexis, uk, or slots frenzy

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>