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

  13. Hololy from plpayboy nakedClinhfield senioir adult center
    unionProgtams too hel tewn offenders1940s 1980s antiqe fine
    jewelry retro sjlver vintaage vitage watchWyoming seex offeder rregistration statutesCockk tqntra cumElder scrokls
    ivv nnude patch imagesFirzt timke gaay cum mastabaton storiesComeddy cawbaret exhibition stri male danhers uk movieTeene sexy mpegsWhooesale vkntage levvis jeansVidss
    ppenis eextension videoBreast milk supply is lowSerr sexDirectt
    too ddive pornShowwtime 2001 adultGalloery
    hajry muffAnime henttai flashBbww haaving ortasm tubeHeteerosexual
    free plrn videosOpeen puswsy centferfold picturesBangin the babysitter sexx
    stoiesAsiuan pic xxx asiaquest pornErotijc escorts sunshine
    coastFrree sex daugghter realAsian drama streaming sitesFreee sexy
    slutsGorgeous blonde teen asturbates her
    shavedFakee courtney smith nudeSophiee hardcoreFree
    ggay fuckingBbbs nude small tteen picturesPussy celeebrity fondaNastyy lesbian strapon aanal tube8Hoot lesbian abes picturesProtoni
    stripLouiise glovcer sexyCabbo sann lucfas adult ame playingTerra patrickk nuse
    picsNude olld homeless guysHandjob love

    My website: jablex.com

  31. how to win on pokie machines australia, best casino deposit bonus 2022 (Christy) deposit bonus
    betting sites new zealand and casino reviews usa, or roulette 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>