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

  1. Definitely consider that that you said. Your favourite justification appeared to be at the net the easiest thing to remember of. I say to you, I definitely get irked whilst people consider concerns that they plainly don’t recognize about. You controlled to hit the nail upon the top and also outlined out the whole thing without having side effect , people can take a signal. Will probably be back to get more. Thank you

  20. free slots australia online, online casino real money free bonus australia and
    online bingo usa, or cherokee casino muskogee (Renate)
    usa bonus

  25. gambling affiliates usa, australian online real money casino and
    legal gambling in united states, or new poker sites uk 2021

    my web-site – blackjack halo attack for sale [Shaunte]

  26. when will pokies reopen south united states,
    the united states casino video and nz casino online, or poker runs united states 2021

    my blog post – gamblers in recovery website (Larae)

  29. mobile casino new united states, real money slots free spins usa and casino free spins no deposit
    required united kingdom, or online casino with free signup bonus real money usa

    Here is my homepage bingo maker join game [Leanne]

  33. what poker sites are legal in united states, rules of gambling usa and uk
    casino 10 no deposit, or milwausaee casino poker

    my homepage … lake tahoe casinos south shore (Leroy)

  34. the great united statesn casino everett, united kingdom online casino accepts poli and
    online casino usa free bonus no deposit, or united states live casino

    Feel free to visit my web blog health benefits of playing bingo
    (Phillis)

  35. paypal gambling sites canada, casino ratings canada and online casino franchise uk,
    or best usa online slot sites

    My web blog: weedmaps blackjack collective (Odette)

  39. australian pm blackjack, is online gambling allowed what does it
    mean to buy in craps – Dian – australia and united statesn casinos no deposit bonus, or no deposit bonus australian online casino

  43. no deposit bonus codes $200 2021 (Justina) deposit mobile casino bonus
    uk, usa gambling ranking and cash freuky casino free chips,
    or online casino united states live dealer

  46. We stumbled over here coming from a different web address and thought I might check things out. I like what I see so now i am following you. Look forward to going over your web page for a second time.

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>