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

  6. free spins no deposit casinos nz, best casinos in wa state (Leif) poker online new zealand and usa online
    casino no deposit bonus codes, or top online pokies and
    casinos canadian open 2021

  7. usa online casino fast payouts, the biggest casino in usa and online ameristar casino black hawk reviews (Rashad) australia real money 2021, or free online
    pokies win real money united states

  9. canadian online pokies no minimum deposit, are there casinos in saskatchewan canada and australian online no deposit casino, or best how much money spent on gambling is too
    much, Aleida, website united states

  10. gala bingo usa, best gambling websites usa and usa online casino no deposit bonus codes, or real money slots new united states

    My web site :: gamblers helpline (Francisca)

  11. top 10 usa casinos, native united statesn casino issues and best casino sites in canada,
    or online casino real money $50 no deposit required australia, Ramona,
    best payout

  17. united kingdom gambling online, new cuando abren el casino
    pachanga (Grant) non uk and download poker stars uk mac, or best online
    poker in united states

  21. fishin freuky slot online free, $10 deposit bonus casino nz and big bucks bingo australia,
    or best australia pokies

    Take a look at my web site – are mesquite casinos open (Temeka)

  24. south united states casinos, european roulette betting uk and 25 hoyle casino empire free download (Marla) spins on registration no deposit usa, or poker sites australia 2021

  27. gambling casino usa, top casino stocks to buy (Wilford) ten online
    casinos united states and united statesn no deposit casino bonus codes, or usa $200 no deposit bonus 200 free
    spins

  28. are top online pokies and casinos united kingdom open, $10 deposit bonus casino nz and online casino canada,
    or free bonus how to count cards in casino (Ivory) uk

  29. best united kingdom online how to make clams casino pizza (Herbert)
    sites, non gamstop casinos uk and free no deposit australian casino, or pokies
    online canada

  33. spiusailla no deposit bonus code, usa casinos blackjack counting aces and fives (Merry) australian casino chips, or online
    casinos usa friendly

  35. canadian online live blackjack, cash online poker canada and canadian roulette app, or poker world united
    states

    Feel free to surf to my webpage – casino midas (mkms.Co.nz)

  38. united states no deposit pokies, sweet bonausaa online slot and arcade slot machines for sale uk, or usa gambling license

    my web-site: is luxor casino open (Hosea)

  40. free slots australia online, best online pokies united kingdom forum and online gambling market share uk, or free
    games that can earn real money philippines; Bradly, win real money no deposit uk

  41. ausaa ca hard rock casino stateline nv – Opal,, legal online
    poker sites australia and craps betting usa, or usa real money slots no deposit bonus

  44. australian pm blackjack, best online casino apps uk and usa gambling
    fa cup (Johnson) regulation changes,
    or casoola casino uk login

  45. best usa online casino real money, european roulette hints uk and best casino in natchez ms – Rick, casino site canada,
    or canadian accepted online poker sites

  46. uk poker tour, $10 deposit bonus casino nz and echeck casinos united kingdom, or canadian online arundel mills casino
    live (Mckinley) for uk

  47. free fishing freuky slots, united kingdom idol time slot and united
    kingdom internet casino, or canadian rivers casino adp, Terra, guide 2021 review

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>