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

  12. triple shot pokies united states, gambling laws canada
    and what makes a good casino dealer (Estella) morning united states
    time slot, or real money online roulette united states

  21. best online poker sites for australia, united kingdom gambling rules and golden pokies united states, or united statesn casino guide roulette

    my site: blackjack bermuda shade tolerance (Corina)

  32. united states no deposit pokies, online bear’s den seneca niagara casino seating chart (Clyde) pokies australia and uk
    casino free bonus, or new casino no deposit
    bonus 2021 uk

  37. casino near heiuk field, are there poker machines in south united kingdom and dollar 1 deposit casino where is the new desert diamond casino – Chau – zealand, or 21 dusaes casino login

  39. casino chains uk, casino 2021 no deposit uk and how much top online pokies and casinos
    united statesn coins, or best online casino to play in united
    states

    Also visit my web blog; braille skate roulette (Annett)

  46. Thanks for your content. One other thing is that if you are selling your property by yourself, one of the troubles you need to be mindful of upfront is just how to deal with house inspection accounts. As a FSBO seller, the key about successfully switching your property along with saving money upon real estate agent profits is understanding. The more you already know, the softer your home sales effort is going to be. One area where this is particularly important is information about home inspections.

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>