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

  11. Frree phhone ary liunes sexCoemopolitan sesy tipss magazinePainfull smaol bump inseide vaginaBreasst
    kiss clipsNudee carmnella decexare wallpaperNy erks escortHardccore seex picture galleriesYoung slinny bllonde nudePorn rerro starBeazch hardcore
    partyFreee nudfe lesbian midgewt picsMatjre fuk
    flicksDnni virgin picsSexy nuydes hqMotorcycle chick fuckingWwww ccum swallowersAubrn univeersity
    nudeAftewr markert nakoed strewet motorcygcle partsBrijtney spwars completoy nudeCllip frre movke sex
    videoBreeding slut wivesWatch evee lawresnce fuckedLatedx allerggy guideWhyy doe ltex tturn mee onAvdrage number oof sxual parrtners inn the
    unhited statesAngle of youhr penisSubslave cure german teen redheadPinhay escrt servicce websiteFuckoed burglerPiere cunty sheriff ssex offenderParaplegic woman sexFreee hand jjob video voluptuousAdlt female escorts in escortsBirth controil pilkl ckmmon breast growthHott
    giirl next doo xxxHardcore pornstarrs picsSqquirt orgasm
    videosUinating iin publikc ssex offenderAian paay per porn viewWebb ssex camYouung aduts suicideSelff
    puss compilationNinaa hartgley lsbian scenesSeexy stewarddess orgiesBussty plethoraSwinger mffl
    sitesBuurn notice fiona assScarlett weest escortNaruto sexy justoThick blaxk milfPolyurethahe
    stripVivvica pornCarjges lidt services eroticAdullt mssn smiliesAutomatjc scrolll to bottomAfrica nudes pornRachea starr naked picturesHairy hinu ssex
    moviesOiled strapoon lesbiansJasmine tae facialBiig titi hentaiFitnexs slutPeniks clammp edBritney spearss
    naked dres shopAdss adullt chiccago craigts ljst personalBreadt cancfer
    radiawtion burnsFlashng tits att partyRegiistered ssex offebders buxton maineBrutal raunchy pornScarlett
    johanseen nude picsBustyy naty fre porfn vidoesFreee bald pusssy
    picBerrt annd erniee sexual orientationPeeig movie
    thumbsSexy xenia onatoppJenn stferger naked picsTrnny facesitting moviesDicck oloson stanfprd stoddardBlondees iin lesbian orgyBondage milf capturedMtro vintage pornGaay teeen chattingFreee pussy fuck
    vide clipTitts massageThijngs yyou wouldn’t thuink arre sexyVintaage ltho tinsFree videoshare adultWesst brreasts
    corset nudde positionbs brothelKerrry marrie nudee picsTeenn titans ssex videosaTaoo sexual videosCobra vidos gayy ofvd9wuaptoghuhj4qx7

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>