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

334 thoughts on “Migrating WordPress to a new URL”

  2. fair go australia pokies, real online money vegas casino cheaters, Francisco, canada and online casinos that accept apple pay usa, or no wagering casino uk

  4. Very good article. I absolutely love this website. Keep writing!

    Look into my page: downloadable craps game free (Rosie)

  5. new zealandn online treasury casino blackjack minimum – Doreen – minimum deposit $10, new online casino canada no deposit and top
    online pokies and casinos australian open, or free chip no deposit united
    states 2021

  7. Its such as you read my thoughts! You seem to understand a
    lot about this, like you wrote the book in it or something.

    I believe that you simply can do with some p.c.
    to pressure the message house a bit, but other than that, this is great blog.

    An excellent read. I will definitely be back.

    My blog: blackjack atx avenger (Doyle)

  9. united kingdom poker deluxe 2, 888 casino canada promo code and ept poker chips in usa, or usa only
    online casinos

    Here is my homepage; high plains bingo (Paul)

  10. top new united statesn online casino, top online pokies and casinos canadian update and online poker united statesn express, or no deposit bonus bingo united states

    Feel free to visit my site – Goplayslots.net

  11. united kingdom online pokies lightning link, are there any
    legal online poker sites in australia and online gambling market share uk, or free spins no wagering requirements usa

    Visit my blog post … top baccarat blog (Kai)

  15. 888 poker deposit united kingdom, best casino united states online and free spins no deposit keep your winnings uk, or dollar 5 deposit online casino free sizzling hot deluxe,
    Damion,
    united kingdom

  17. australian online casinos that accept paypal,
    united kingdom idol time slot and play slots for real money usa,
    or live online roulette united states

    My web blog is northern edge casino open to the public
    (Sarah)

  18. Appreciation to my father who shared with me concerning this web site, this webpage is casinonic legit (Harley) in fact
    amazing.

  19. new no deposit casino canada, top canadian casinos in axis and craps betting usa, or united statesn online is dakota dunes casino
    open today (Cesar)
    best

  20. online uk bingo reviews, best canada online pokies and free
    bonus no deposit roulette usa, or dragon link online pokies canada

    Also visit my blog: blackjack electronic table games (Vida)

  21. all new zealandn casino, bonauka gambling machine and play online
    usa roulette biased wheel; Susanna,, or highest payout
    online casino usa

  22. best uk slot bonus, casino nsw united states
    and play slots for real money usa, or can i use td canada trust visa debit
    for online casino in india without deposit (Christal)
    gambling

  24. online pokies canada real, 50 free spins
    no deposit 2021 nz and free casino no deposit bonus uk, or when was the first royal flush casino houma la; Flossie,
    built in australia

  31. how much top online pokies and casinos australian games, united kingdom roulette
    payout calculator and new things to consider before gambling online – Juliana
    - legislation united states, or newest online casino 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>