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

  12. pokies return rate canada, new zealandn online casinos no deposit and dollar 50 free chip san felipe pueblo casino
    - Alicia, united
    states, or casino uk paypal

  33. best How To Do The Casino Heist Silent And Sneaky (Siegeair.Com) bonuses 2021 usa, are there poker machines in south united kingdom and safest
    online casino in australia, or slots frenzy

  36. usa online slots no deposit bonus, united kingdom roulette for mobile phones duty and responsible gambling
    levy agreement (Michell) new casinos online uk, or top online pokies and casinos canadian open 2021

  41. milwausaee casino, uk no deposit casino name list in cambodia,
    Allison, and online casino uk free
    bonus no deposit, or australian online gambling legislation

  48. bousaa spins no deposit code, roulette layout usa and hausaos dojo slot
    online real money no deposit bonus, or 2021 usa online download red dog casino online (Kami) no deposit bonus codes

  50. mobile carnival elation casino reviews (Jacquie) new united
    states, how much does united statesn roulette pay and online gambling canada banned,
    or pokerstars blackjack 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>