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

2,865 thoughts on “Migrating WordPress to a new URL”

  1. top bingo site usa, united kingdom no deposit signup bonus casino and
    gambling times usa, or nz online casinos that accept paypal

    Also visit my web page – where is the gambler 500, Sheree,

  3. the top online casino for real money in india (Bob) pokies
    and casinos in united states legit, canadian poker admiral and usa casino news,
    or australian online casino no deposit signup bonus

  4. uk casino no deposit bonus no wagering, legal canadian online pokies and
    online gambling south australia, or best is crown casino open anzac day (Marcelino) sites in united states

  5. united statesn cash frenzy casino free games (Milagro) no deposit free spins, are there casinos in toronto united states and can us citizens play online poker in united states, or free online pokies win real money united states

  7. new zealandn poker 2 play blackjack free with other players online (Fawn) game, online casinos free spins no deposit usa approved and online pokies paysafe united states, or bonus freuky slots

  10. legal gambling sites australia, free spins new casino usa and
    casino apps real money australia, or how to win at united statesn roulette

    Here is my website; nv casinos open (Precious)

  11. $1 min deposit casino australia, no deposit bingo bonus uk and big bucks bingo australia, or paypal online casino uk

    Also visit my webpage – what pokies are open today (Michaela)

  13. best uk slot bonus, black chip poker united kingdom and united kingdom online olg casino online app (Jennie) no
    deposit bonus codes 2021, or united statesn poker tournament

  15. gold coast casino australia, how much top online pokies and
    casinos australian coins and poker run thousand islands 2021, or best online plainridge casino
    foxboro ma, Carma, for slots uk

  16. canadian casino guide blackjack chart, online slot casino usa and free bonus no deposit casino usa, or free
    spins casino no deposit bonus united states

    Stop by my web blog … how to make money on bigo live; Eli,

  19. the blackjacks homepage canada, casino winnings tax free in canada and cahuilla casino anza california, or top
    online pokies nz

    Feel free to surf to my homepage; gambling age lower – 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>