{"id":348,"date":"2014-07-20T21:41:09","date_gmt":"2014-07-20T21:41:09","guid":{"rendered":"https:\/\/ahorseforonebin.co.uk\/?p=348"},"modified":"2014-07-20T21:41:09","modified_gmt":"2014-07-20T21:41:09","slug":"well-thats-very-odd","status":"publish","type":"post","link":"https:\/\/ahorseforonebin.co.uk\/?p=348","title":{"rendered":"well that’s very odd"},"content":{"rendered":"

I wanted to move my TLD and blog (resides in a trailing sub-dir) from Arizona to my state-of-the-art datacentre in my house in Rugby, so:<\/p>\n

    \n
  1. I backed up (and exported to my local hard-disc), the MySQL databases for the TLD and for the blog.<\/li>\n
  2. I FTPd the content plus WordPress files from Arizona to my local hard-disc.<\/li>\n
  3. In phpMyAdmin I created two users and an\u00a0associated database for each user<\/li>\n
  4. I imported the exported MySQL databases in to each new instance (both completed with non errors)<\/li>\n
  5. I created the webspace on my NAS, and copied the WordPress files plus content in to it – changing the wpconfig.php in both the TLD and the blog sub-dir for the user details I had created in step 3.<\/li>\n
  6. I logged on to the domain admin panel and changed the root IP address from the Arizona datacentre to the Rugby one<\/li>\n
  7. Waited<\/li>\n<\/ol>\n

    After about 10 minutes the TLD had completed the propagation; I had full navigation being served up by the Rugby environment.<\/p>\n

    However the blog sub-dir failed: when I tried to access it I just got a blank screen of whiteness.<\/p>\n

    I dropped all of the tables in the database and did another import (which completed successfully).<\/p>\n

    And got the same white space.<\/p>\n

    So I deleted the MySQL database and the user, and tried to access the blog – and got a Database Connection error message, which is what I’d expect.<\/p>\n

    Then I created a new database to match the same credentials I’d created in the wpconfig.php file, and imported the old MySQL database again.<\/p>\n

    It failed once more; same white screen.<\/p>\n

    Hmm.<\/p>\n

    This needs thinking about.<\/p>\n","protected":false},"excerpt":{"rendered":"

    I wanted to move my TLD and blog (resides in a trailing sub-dir) from Arizona to my state-of-the-art datacentre in my house in Rugby, so: I backed up (and exported to my local hard-disc), the MySQL databases for the TLD and for the blog. I FTPd the content plus WordPress \u2026 Continue reading → <\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-348","post","type-post","status-publish","format-standard","hentry","category-admin"],"_links":{"self":[{"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=348"}],"version-history":[{"count":1,"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/348\/revisions"}],"predecessor-version":[{"id":349,"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/348\/revisions\/349"}],"wp:attachment":[{"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}