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

  13. free united statesn pokies online, non gamstop casinos uk and blackjack mulligan usa, or deposit 10 get usa

    Look at my web blog :: penny casino stocks; Romaine,

  15. slots best uk, spin casino australia and free spins no deposit casino uk
    new, or online pokies australia wheres the gold

    My homepage: roulette playing tricks (Louis)

  16. independent online casino usa, golden tiger casino uk and canadian poker, or new no deposit free
    spins uk 2021

    my site best winning casinos in vegas (Kay)

  21. united statesn gambling news, best usa poker rooms and online gambling laws new zealand, or
    usa online casinos free play

    my page; bus to sands casino from nyc, Cheryl,

  22. biggest usa gambling sites, chusachansi casino takeover and
    no deposit slots usa, or betsoft no deposit bonus united states

    Here is my blog post: fanduel blackjack rigged – Garry,

  23. best poker app usa, cash online poker canada and download poker stars uk mac, or new zealand real money slots

    my blog: casinos gambling facilities – Blaine,

  25. online casino canada easy withdrawal, bet365 new zealandn roulette
    instructions and no deposit mobile casino canada, or buy bingo game australia

    my page test gambling site (Hermine)

  32. vegas gambling statistics (Leta) legal in usa, best usa online casino bonuses and free spins no deposit united
    statesn pokies, or australian open gambling

  33. best gambling website canada, united states
    day free spins and best online casino instant verification (Deborah) casino
    app usa, or new zealandn online casino real money 2021

  35. online pokies canada real, jackpot capital casino codes (Garnet) in cambridge usa and united kingdom slots machines, or united
    statesn casino regulation

  36. online new mobile casino 2022, Rhea, free bet no deposit uk,
    casino winnings tax free in canada and uk casino free
    bonus, or native united statesn casinos in montana

  39. minimum deposit casinos usa, united statesn original slot machine game and casino online australia free, or most legit online casino united states

    Here is my web page :: blackjack for android download (Melodee)

  42. blackjack united kingdom general, casino
    victoria bc canada and new zealandn real money pokies, or no deposit bonus casino microgaming australia

    my web-site; d3 kadala gambling [Adam]

  44. all slots online nz casino, online casino uk best and usa admiral shark casino login (Shanice) news, or 5 dollar deposit casino united kingdom

  45. best united kingdom online casino sites, no deposit canada casino bonus and canada online gambling
    laws, or real money payment processing for online gambling
    (Terrell) casino united states reviews

  47. no deposit online pokies nz, casinos no deposit bonus uk and online pokies canada
    jokaroom, or australia gambling sites

    My homepage :: how much to bet on side bets in blackjack – Roxana,

  50. android river spirit casino birthday free play (Celinda) united kingdom, top
    poker sites uk and is bingo gambling in canada, or online blackjack canada paypal

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>