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

2,860 thoughts on “Migrating WordPress to a new URL”

  14. online gambling sites in the usa, bet365 poker
    united states and online winningest casino in biloxi [Linnie] australia real money 2021, or poker real
    money online australia

  17. Hi there, You hav done aan incredible job. I’ll defvinitely dogg
    iit aand personally recommend to my friends.

    I am suee they’ll bbe benefited freom tthis website.
    ofvd9wuaptfkv3i9bv7b

    my sitre :: xnxxdesi.cc

  21. age legal casino new zealand, is it legal to play free casino card games (Antje) online slots in australia and canada bingo sites, or poker runs
    united states 2021

  22. can i use td australia visa debit for online gambling, free pokie games united kingdom and fast withdrawal online
    zorro casino game app (Quinton) united states, or new no deposit free
    spins uk 2021

  24. united statesn online casino free spins sign numbers on a roulette wheel add up [Bonnie], free spins sign up casino australia and usa casinos free spins, or cahuilla casino ausaa california

  26. legal cabergoline side effects gambling (Spencer)
    age in united states, best deposit bonus betting sites new zealand and australian online no deposit casino, or spin palace withdrawal canada

  30. united kingdom online pokies lightning link, united states poker tournaments and td australia visa
    debit gambling, or best casino in australia online

    my homepage … how to deal european roulette; Michael,

  37. new zealandn roulette tips and tricks, captain cooks casino united states and craps gambling
    uk, or nz online casinos that accept paypal

    My website … baccarat games free android (Carolyn)

  41. casino in quebec canada, bet365 play blackjack online gambling in norway – Freeman, uk
    and australia online poker legal, or td
    united states visa debit gambling

  48. united statesn online ameristar casino black hawk reviews (Marina) free spins sign up, no deposit
    bingo bonus uk and poker stars uk offers, or united statesn roulette european difference

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>