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

  1. fastpay casino uk, how to win at roulette uk and united kingdom online pokies welcome
    bonus, or united kingdom poker 95 download

    Here is my web site … improve your gambling skills (Alice)

  2. usa casino free spins 2021, free spins no deposit usa 888 and big usa slot wins, or usa real money slots no deposit bonus

    my blog post :: best way to win gambling in vegas (Staci)

  5. online casino real money no deposit australia, united kingdom poker
    texas holdem and 200 free spins no deposit canada, or best real money poker
    app usa

    Check out my website craps strategy come line, Regan,

  11. play pokies online free canada, gambling startup ventures (Margery) statistics australia 202 and paypal bingo sites uk, or registration bonus
    casino usa

  12. e wallet for gambling – Dante – illegal usa, 2021 no deposit bonus codes nz and online casino
    uk free bonus no deposit, or top online pokies and casinos in united states 4k

  14. regulation of gambling is there a casino in bimini bahamas (Lauri) canada, aristocrat lightning
    link pokies united kingdom versions and how can i play online
    poker in united states, or free bingo games no deposit
    usa

  16. bingo canada sign up, play free slots united states and all australian casino bonus codes, or best craps online canada

    My web page … opel ascona blackjack kaufen (Odette)

  22. real money casino usa online, legitimate online pokies australia and where can i play poker
    online baccarat rules for beginners (Felisha)
    real money in australia, or best no deposit casinos aus

  24. mid united states casinos, bet365 poker united states and australian online bingosys net no deposit – Leslie – deposit casino, or how to win at
    united statesn roulette

  25. free spins how to play the card game casino (Donny) no deposit usa, mini slot machine united states
    and hausaos dojo slot online real money no deposit bonus, or united kingdom civil war poker tables

  31. best free online casino new zealand, 100 slots bonus uk and real
    online casino australia, or slots frenzy

    Feel free to surf to my website … skill on net casinos (Ernestine)

  33. auto wheel roulette play usa dark web online casino (Sheila), australian online pokies minimum $5 deposit and craps gambling uk, or poker sites canada

  40. united kingdom lynne blackjack black (Lina) rules, australia gambling winnings taxable
    and how to win china africa bonausaa slot machine, or latest australian slot machines

  41. best casino app in usa, western australian poker league and best casino in new zealand, or usa online casino zitobox
    no deposit promo codes (Edna) deposit bonus codes 2021

  50. 25 free spins on sign up australia, slot machine australia and best online
    real money slots new zealand, or craps guide
    uk

    Feel free to visit my site roulette betting types – Brenda -

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>