{"id":61011,"date":"2020-11-09T04:08:55","date_gmt":"2020-11-09T04:08:55","guid":{"rendered":"https:\/\/blog.glaciermediadigital.ca\/?p=61011"},"modified":"2020-11-09T23:43:28","modified_gmt":"2020-11-09T23:43:28","slug":"two-developer-tips-first-migration","status":"publish","type":"post","link":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/","title":{"rendered":"Two Developer Tips for Your First Migration"},"content":{"rendered":"

Navigating your first WordPress migration can be an intimidating and treacherous process. Every developer has their horror stories of broken pages, missing images and session timeouts. Some of these are inevitable and should be taken with pride in the name of learning. In this article we\u2019ll go over a couple things to keep in mind so you can keep your first WordPress site migration as smooth as possible.<\/span><\/p>\n

Don\u2019t query about queries<\/strong><\/p>\n

A crucial step in migrating a WordPress site is making sure the database is pointing to the right URL once it\u2019s been imported into its new destination. Having a master SQL command that you can reference saves time and headaches. We use the following once a database has been uploaded to its destination server to point it in the right direction:<\/p>\n

UPDATE wp_options SET option_value = replace(option_value, ‘http:\/\/previousurl.com’, ‘https:\/\/currenturl.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;<\/p>\n

UPDATE wp_posts SET guid = REPLACE (guid, ‘http:\/\/previousurl.com’, ‘https:\/\/currenturl.com’);<\/p>\n

UPDATE wp_posts SET post_content = REPLACE (post_content, ‘http:\/\/previousurl.com’, ‘https:\/\/currenturl.com’);\u200b<\/p>\n

UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, ‘http:\/\/previousurl.com’, ‘https:\/\/currenturl.com’);<\/p>\n

When using a master command such as this be mindful of which URL you are changing and whether you are migrating to an SSL (HTTPS) enabled server or not.<\/p>\n

Screenshot, Screenshot, Screenshot<\/strong><\/p>\n

Taking screenshots and recording your steps is one of the most 20\/20 hindsight things you can cover during a migration. Various pages and views of a website pre-migration as well as DNS settings *before* they are switched over are crucial things to have handy, as setting these back to their original state can be a time sink or not even possible in some cases. The extra second this takes could be saving you hours of troubleshooting later on.<\/p>\n

Disclaimer: This is not a front-to-back tutorial for migrating a WordPress site, and there are many great resources for that online already. These are just extra tips that may help you find a migration process that works for you. Please use in conjunction with a reputable guide for WordPress migrations.<\/em><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

In this article we\u2019ll go over a couple things to keep in mind so you can keep your first Wordpress site migration as smooth as possible.<\/p>\n","protected":false},"author":13,"featured_media":61012,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[156],"tags":[82],"class_list":["post-61011","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-websites","tag-website"],"yoast_head":"\nTwo Developer Tips for Your First Migration -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Two Developer Tips for Your First Migration -\" \/>\n<meta property=\"og:description\" content=\"In this article we\u2019ll go over a couple things to keep in mind so you can keep your first Wordpress site migration as smooth as possible.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-09T04:08:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-11-09T23:43:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.lodestardigital.ca\/wp-content\/uploads\/2020\/11\/iStock-1047259374.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"724\" \/>\n\t<meta property=\"og:image:height\" content=\"483\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Glacier Media\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glacier Media\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/\"},\"author\":{\"name\":\"Glacier Media\",\"@id\":\"https:\/\/blog.lodestardigital.ca\/#\/schema\/person\/cf060f34beff5b459e02e7e731cc80e7\"},\"headline\":\"Two Developer Tips for Your First Migration\",\"datePublished\":\"2020-11-09T04:08:55+00:00\",\"dateModified\":\"2020-11-09T23:43:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/\"},\"wordCount\":369,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.lodestardigital.ca\/wp-content\/uploads\/2020\/11\/iStock-1047259374.jpg\",\"keywords\":[\"website\"],\"articleSection\":[\"websites\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/\",\"url\":\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/\",\"name\":\"Two Developer Tips for Your First Migration -\",\"isPartOf\":{\"@id\":\"https:\/\/blog.lodestardigital.ca\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.lodestardigital.ca\/wp-content\/uploads\/2020\/11\/iStock-1047259374.jpg\",\"datePublished\":\"2020-11-09T04:08:55+00:00\",\"dateModified\":\"2020-11-09T23:43:28+00:00\",\"author\":{\"@id\":\"https:\/\/blog.lodestardigital.ca\/#\/schema\/person\/cf060f34beff5b459e02e7e731cc80e7\"},\"breadcrumb\":{\"@id\":\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#primaryimage\",\"url\":\"https:\/\/blog.lodestardigital.ca\/wp-content\/uploads\/2020\/11\/iStock-1047259374.jpg\",\"contentUrl\":\"https:\/\/blog.lodestardigital.ca\/wp-content\/uploads\/2020\/11\/iStock-1047259374.jpg\",\"width\":724,\"height\":483,\"caption\":\"Creative abstract PHP web design, internet programming HTML language and digital computer technology business concept: 3D render illustration of the macro view of software source code on screen monitor with selective focus effect\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blog.lodestardigital.ca\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Two Developer Tips for Your First Migration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.lodestardigital.ca\/#website\",\"url\":\"https:\/\/blog.lodestardigital.ca\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.lodestardigital.ca\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.lodestardigital.ca\/#\/schema\/person\/cf060f34beff5b459e02e7e731cc80e7\",\"name\":\"Glacier Media\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blog.lodestardigital.ca\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/71173b2fa56c2efb47938ab1a2c8bfa0c2670da463b7677d2d79a5753dcc45ca?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/71173b2fa56c2efb47938ab1a2c8bfa0c2670da463b7677d2d79a5753dcc45ca?s=96&d=mm&r=g\",\"caption\":\"Glacier Media\"},\"url\":\"https:\/\/blog.lodestardigital.ca\/index.php\/author\/glacier-media-digital\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Two Developer Tips for Your First Migration -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/","og_locale":"en_US","og_type":"article","og_title":"Two Developer Tips for Your First Migration -","og_description":"In this article we\u2019ll go over a couple things to keep in mind so you can keep your first Wordpress site migration as smooth as possible.","og_url":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/","article_published_time":"2020-11-09T04:08:55+00:00","article_modified_time":"2020-11-09T23:43:28+00:00","og_image":[{"width":724,"height":483,"url":"https:\/\/blog.lodestardigital.ca\/wp-content\/uploads\/2020\/11\/iStock-1047259374.jpg","type":"image\/jpeg"}],"author":"Glacier Media","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Glacier Media","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#article","isPartOf":{"@id":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/"},"author":{"name":"Glacier Media","@id":"https:\/\/blog.lodestardigital.ca\/#\/schema\/person\/cf060f34beff5b459e02e7e731cc80e7"},"headline":"Two Developer Tips for Your First Migration","datePublished":"2020-11-09T04:08:55+00:00","dateModified":"2020-11-09T23:43:28+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/"},"wordCount":369,"commentCount":0,"image":{"@id":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.lodestardigital.ca\/wp-content\/uploads\/2020\/11\/iStock-1047259374.jpg","keywords":["website"],"articleSection":["websites"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/","url":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/","name":"Two Developer Tips for Your First Migration -","isPartOf":{"@id":"https:\/\/blog.lodestardigital.ca\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#primaryimage"},"image":{"@id":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.lodestardigital.ca\/wp-content\/uploads\/2020\/11\/iStock-1047259374.jpg","datePublished":"2020-11-09T04:08:55+00:00","dateModified":"2020-11-09T23:43:28+00:00","author":{"@id":"https:\/\/blog.lodestardigital.ca\/#\/schema\/person\/cf060f34beff5b459e02e7e731cc80e7"},"breadcrumb":{"@id":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#primaryimage","url":"https:\/\/blog.lodestardigital.ca\/wp-content\/uploads\/2020\/11\/iStock-1047259374.jpg","contentUrl":"https:\/\/blog.lodestardigital.ca\/wp-content\/uploads\/2020\/11\/iStock-1047259374.jpg","width":724,"height":483,"caption":"Creative abstract PHP web design, internet programming HTML language and digital computer technology business concept: 3D render illustration of the macro view of software source code on screen monitor with selective focus effect"},{"@type":"BreadcrumbList","@id":"https:\/\/blog.lodestardigital.ca\/index.php\/2020\/11\/09\/two-developer-tips-first-migration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.lodestardigital.ca\/"},{"@type":"ListItem","position":2,"name":"Two Developer Tips for Your First Migration"}]},{"@type":"WebSite","@id":"https:\/\/blog.lodestardigital.ca\/#website","url":"https:\/\/blog.lodestardigital.ca\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.lodestardigital.ca\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blog.lodestardigital.ca\/#\/schema\/person\/cf060f34beff5b459e02e7e731cc80e7","name":"Glacier Media","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.lodestardigital.ca\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/71173b2fa56c2efb47938ab1a2c8bfa0c2670da463b7677d2d79a5753dcc45ca?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/71173b2fa56c2efb47938ab1a2c8bfa0c2670da463b7677d2d79a5753dcc45ca?s=96&d=mm&r=g","caption":"Glacier Media"},"url":"https:\/\/blog.lodestardigital.ca\/index.php\/author\/glacier-media-digital\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.lodestardigital.ca\/index.php\/wp-json\/wp\/v2\/posts\/61011","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.lodestardigital.ca\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.lodestardigital.ca\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.lodestardigital.ca\/index.php\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.lodestardigital.ca\/index.php\/wp-json\/wp\/v2\/comments?post=61011"}],"version-history":[{"count":0,"href":"https:\/\/blog.lodestardigital.ca\/index.php\/wp-json\/wp\/v2\/posts\/61011\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.lodestardigital.ca\/index.php\/wp-json\/wp\/v2\/media\/61012"}],"wp:attachment":[{"href":"https:\/\/blog.lodestardigital.ca\/index.php\/wp-json\/wp\/v2\/media?parent=61011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.lodestardigital.ca\/index.php\/wp-json\/wp\/v2\/categories?post=61011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.lodestardigital.ca\/index.php\/wp-json\/wp\/v2\/tags?post=61011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}