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

  1. european online casinos real money usa players free spins,
    free pokie games nz and no verification casino australia, Dollie, deposit bonus slots australia,
    or new poker sites uk 2021

  12. latest online gambling checks (Willis)
    casinos canada, bet365 new zealandn roulette instructions
    and rules of roulette uk, or real money slots new united
    states

  34. no deposit bonus codes usa, review casino royale (Jess)
    games canada and can you play poker for money online in united
    kingdom, or united statesn poker tournament

  40. casino winnings taxable in united kingdom, argos uk poker chips and
    same-day withdrawal online casinos united states, or top paying online casinos united states

    My blog post :: god say about gambling (Margaret)

  44. best rated payout online casino nz, grand dusae lakeside casino in pahrump nv (Kandace) no deposit bonus and best online casino payout uk, or online casino bc australia

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>