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”

  30. statistics of gambling in canada, play real money poker online casino registrierung bonus (Essie) australia and casino dusaes no deposit bonus codes,
    or united kingdom indians casinos

  31. best rated payout online casino nz, can do you need id to
    gamble in vegas (Micheal) play poker online for real money in united kingdom and online gambling laws new zealand, or no deposit roulette bonus usa

  34. bousaa spins no deposit code, how to win at date idea roulette
    (Miranda) uk and the largest casino in australia, or new zealandn online pokies min $5
    deposit

  36. free online slots nz, no deposit sign up bonus nz 2021 and united kingdom online pokies welcome bonus, or casino sharon stone mercedes (Marquita)
    online united kingdom free

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>