{"id":809,"date":"2010-06-20T10:12:29","date_gmt":"2010-06-20T04:42:29","guid":{"rendered":"http:\/\/naveenbalani.com\/?p=809"},"modified":"2016-09-17T10:24:58","modified_gmt":"2016-09-17T04:54:58","slug":"migrating-wordpress-blog-acrosss-domains","status":"publish","type":"post","link":"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/","title":{"rendered":"Migrating wordpress blog acrosss domains"},"content":{"rendered":"

Recently, I migrated my word press domain from my earlier site (soaweb.co.in) to my new web site (naveenbalani.com).\u00a0 Here are the steps, I followed<\/p>\n

    \n
      \n
    1. Exported my earlier wordpress database using phpAdmin<\/li>\n
    2. Installed word press on my new website. Just copied the wordpress install files on new domain\u00a0 web root.<\/li>\n
    3. Created a new database for the new domain.<\/li>\n
    4. Imported the database.zip from Step 1 to new database.<\/li>\n
    5. Changed the following 2 records in wp_options table which mentioned my old wordpress blog URL<\/li>\n<\/ol>\n<\/ol>\n

      Update option_value column with \u201cnewUrl\u201d where option_name =\u201dsiteurl<\/em><\/p>\n

      Update option_value column with \u201cnewUrl\u201d where option_name =\u201dhome\u201d<\/em><\/p>\n

        \n
      1. Changed the wp-config.php of the new domain to point to new database<\/li>\n
      2. Logon to Word Press and change the path of uploaded media content files for future uploads to relative one.\u00a0\u00a0 Navigate to Settings > Miscellaneous Settings and change it to Store uploads in this folder to \/ wp-content\/uploads.This might be optional, but in my case the hosting provider had appended the complete path , instead of relative one.<\/li>\n<\/ol>\n

        I than did a search on my new wordpress blog table to find out references of my earlier url (soaweb.co.in) and found
        \nthere where still entries remaining in wp_posts table. The wp_posts\u00a0 table stores the revision history, if you have enabled it.I had enabled revision history, so I went ahead and deleted all my revsion history since I didn’t require it any more , using the following SQL command in phpAdmin<\/p>\n

        DELETE FROM wp_posts WHERE post_type = “revision”;<\/em><\/p>\n

        Few other references (the guid column) pointed to my earlier blog url, so did a mass replace using the following command. The guid was the short url of the blog. This technique you can use to replace all references quickly.<\/p>\n

        UPDATE wp_posts SET guid = REPLACE(guid,”soaweb.co.in” ,”naveenbalani.com”)<\/p>\n

        That\u2019s it, I now have my website up and running.<\/p>\n

        One of the things, I realized was that in my earlier blogs, the URL references and images was hard coded, instead of referencing them. This required an extra effort to move the urls to the new domain. Other thing, I noticed was, that I had used Rich text (imported my content from words), in that case the export didn\u2019t handle the special characters well (like bullets), I had to change that manually.<\/p>\n

        I tried the entire setup on my local environment using xampplite environment and than moved it over to my hosting provider. Hope this would give you some insights if you plan to move your word press blog. And if you have been following my blog on soaweb.co.in , this would now be redirected to this website.<\/p>\n","protected":false},"excerpt":{"rendered":"

        Recently, I migrated my word press domain from my earlier site (soaweb.co.in) to my new web site (naveenbalani.com).\u00a0 Here are the steps, I followed Exported my earlier wordpress database using phpAdmin Installed word press on my new website. Just copied the wordpress install files on new domain\u00a0 web root. Created a new database for the […]<\/p>\n","protected":false},"author":1,"featured_media":2128,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,120],"tags":[99,98],"yoast_head":"\nMigrating wordpress blog acrosss domains - Current and Future Technology Trends by Navveen Balani<\/title>\n<meta name=\"description\" content=\"Migrating wordpress blog acrosss domains -\" \/>\n<link rel=\"canonical\" href=\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrating wordpress blog acrosss domains - Current and Future Technology Trends by Navveen Balani\" \/>\n<meta property=\"og:description\" content=\"Migrating wordpress blog acrosss domains -\" \/>\n<meta property=\"og:url\" content=\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/\" \/>\n<meta property=\"og:site_name\" content=\"Current and Future Technology Trends by Navveen Balani\" \/>\n<meta property=\"article:published_time\" content=\"2010-06-20T04:42:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-09-17T04:54:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/navveenbalani.dev\/wp-content\/uploads\/2016\/09\/bk6.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"450\" \/>\n\t<meta property=\"og:image:height\" content=\"374\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data1\" content=\"2 minutes\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/navveenbalani.dev\/#website\",\"url\":\"https:\/\/navveenbalani.dev\/\",\"name\":\"Current and Future Technology Trends by Navveen Balani\",\"description\":\"Current and Future Technology Trends by Navveen Balani\",\"publisher\":{\"@id\":\"https:\/\/navveenbalani.dev\/#\/schema\/person\/51f7ab14b20611d95e3c7fd4ea0950bf\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/navveenbalani.dev\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/navveenbalani.dev\/wp-content\/uploads\/2016\/09\/bk6.jpg\",\"width\":450,\"height\":374},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/#webpage\",\"url\":\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/\",\"name\":\"Migrating wordpress blog acrosss domains - Current and Future Technology Trends by Navveen Balani\",\"isPartOf\":{\"@id\":\"https:\/\/navveenbalani.dev\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/#primaryimage\"},\"datePublished\":\"2010-06-20T04:42:29+00:00\",\"dateModified\":\"2016-09-17T04:54:58+00:00\",\"description\":\"Migrating wordpress blog acrosss domains -\",\"breadcrumb\":{\"@id\":\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/navveenbalani.dev\/\",\"url\":\"https:\/\/navveenbalani.dev\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/\",\"url\":\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/\",\"name\":\"Migrating wordpress blog acrosss domains\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/#webpage\"},\"author\":{\"@id\":\"https:\/\/navveenbalani.dev\/#\/schema\/person\/51f7ab14b20611d95e3c7fd4ea0950bf\"},\"headline\":\"Migrating wordpress blog acrosss domains\",\"datePublished\":\"2010-06-20T04:42:29+00:00\",\"dateModified\":\"2016-09-17T04:54:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/#webpage\"},\"commentCount\":5,\"publisher\":{\"@id\":\"https:\/\/navveenbalani.dev\/#\/schema\/person\/51f7ab14b20611d95e3c7fd4ea0950bf\"},\"image\":{\"@id\":\"https:\/\/navveenbalani.dev\/index.php\/articles\/migrating-wordpress-blog-acrosss-domains\/#primaryimage\"},\"keywords\":\"wordpress,wordpress migration\",\"articleSection\":\"Articles,Blog & CMS\",\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/navveenbalani.dev\/#\/schema\/person\/51f7ab14b20611d95e3c7fd4ea0950bf\",\"name\":\"Navveen\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/navveenbalani.dev\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/navveenbalani.dev\/wp-content\/uploads\/2019\/07\/navveen_balani.jpeg\",\"width\":200,\"height\":200,\"caption\":\"Navveen\"},\"logo\":{\"@id\":\"https:\/\/navveenbalani.dev\/#personlogo\"},\"sameAs\":[\"http:\/\/naveenbalani.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/navveenbalani.dev\/index.php\/wp-json\/wp\/v2\/posts\/809"}],"collection":[{"href":"https:\/\/navveenbalani.dev\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/navveenbalani.dev\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/navveenbalani.dev\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/navveenbalani.dev\/index.php\/wp-json\/wp\/v2\/comments?post=809"}],"version-history":[{"count":9,"href":"https:\/\/navveenbalani.dev\/index.php\/wp-json\/wp\/v2\/posts\/809\/revisions"}],"predecessor-version":[{"id":2166,"href":"https:\/\/navveenbalani.dev\/index.php\/wp-json\/wp\/v2\/posts\/809\/revisions\/2166"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/navveenbalani.dev\/index.php\/wp-json\/wp\/v2\/media\/2128"}],"wp:attachment":[{"href":"https:\/\/navveenbalani.dev\/index.php\/wp-json\/wp\/v2\/media?parent=809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/navveenbalani.dev\/index.php\/wp-json\/wp\/v2\/categories?post=809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/navveenbalani.dev\/index.php\/wp-json\/wp\/v2\/tags?post=809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}