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

1,125 thoughts on “Migrating WordPress to a new URL”

  8. 500 free spins no deposit united states, best casinos in south united states and
    united statesn real pokies online, or free bonus casino uk

    Here is my site :: gambler domain genshin [Marilynn]

  36. Magnificent beat ! I would like to apprentice while you
    amend your web site, how could i subscribe for a blog web site?

    The account aided me a acceptable deal. I had been tiny bit acquainted of this your
    broadcast provided bright clear idea

    Feel free to visit my web page: basketball wetten handicap (Rochelle)

  37. Excellent pieces. Keep writing such kind of information on your blog.
    Im really impressed by your site.
    Hey there, You’ve done an excellent job. I’ll definitely digg it and in my view suggest to my
    friends. I’m confident they will be benefited from this website.

    my web-site … Basketball wetten tips

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>