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

  6. poker united statesno gratis, online bingo uk
    no deposit and free bingo australia, or betsoft no
    deposit bonus united states

    My web-site: best pc blackjack game – Olivia -

  10. Yesterday, while I was at work, my sister stole my apple ipad and tested to see if it can survive a 40 foot drop, just so she can be a youtube sensation. My iPad is now destroyed and she has 83 views. I know this is totally off topic but I had to share it with someone!

  45. real money gambling online canada, online albert lea mn to diamond jo
    casino – Vernon – no deposit bonus free spins usa and australia gambling statistics, or free games win real money
    no deposit uk

  47. online pokies australia 5 dollar deposit, craps tutorial usa and
    online poker united statesn express, or the top online pokies and casinos in united states

    My blog post; casino profits (Jung)

  50. free online slots new zealand, australian online how to earn from
    casino (Ian) deposit bonus and online pokies united
    states no deposit signup bonus, or list of casinos in canada

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>