{"id":11,"date":"2005-10-27T04:32:20","date_gmt":"2005-10-27T04:32:20","guid":{"rendered":"http:\/\/blog.cyberwizzard.nl\/?p=11"},"modified":"2016-03-17T21:25:14","modified_gmt":"2016-03-17T20:25:14","slug":"mysql-update-complete","status":"publish","type":"post","link":"https:\/\/blog.cyberwizzard.nl\/?p=11","title":{"rendered":"MySQL update complete&#8230;"},"content":{"rendered":"<p>Remembering the saying:<br \/> &nbsp;&nbsp;&nbsp; It if ain&#8217;t broken, do not fix it!<br \/> I left my server untouched as pretty much everything on there is in use so wrecking stuff might be a problem \ud83d\ude42<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/sportlaan.adsl.utwente.nl\/joomla\/images\/stories\/computer\/cool.png\" style=\"float: right;\" hspace=\"6\" alt=\"Image\" title=\"Image\" border=\"0\" \/>However, after 9 months or so I decided it was about time to update the server and make sure everything works as expected (again). I extracted the database content as the update guide explained and started the mysql compile for upgrade. 15 minutes or so in the compile I discovered that the SQL export file was empty&#8230; After cursing and some frantic Googling I decided to stop the compile, copy the raw database files back and keep my fingers crossed as I fired up the incomplete mysql server.<\/p>\n<p> Although I saw loads of errors it seemed to come online &#8211; sorta.<br \/> I tried extracting the data once more, copied the backup, backed up that one once more, moved it off site and then made the whole collection read-only &#8211; just to be sure, ya know \ud83d\ude1b<\/p>\n<p> After 3 more hours of compiling (why did I shut down the compiler again?!) it was finally done and after some agonising moments after entering the startup and import commands I was relieved to see the whole shabang coming back to life.<\/p>\n<p> I was planning on doing the apache server next but for now l think I&#8217;ll leave it at this \ud83d\ude42<\/p>\n<p> Cyberwizzard signing off at 4:31 AM&#8230; <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Remembering the saying: &nbsp;&nbsp;&nbsp; It if ain&#8217;t broken, do not fix it! I left my server untouched as pretty much everything on there is in use so wrecking stuff might be a problem \ud83d\ude42 However, after 9 months or so I decided it was about time to update the server and make sure everything works [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[459],"class_list":["post-11","post","type-post","status-publish","format-standard","hentry","category-general-blog-entries","tag-not_ok"],"views":4870,"_links":{"self":[{"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/posts\/11","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11"}],"version-history":[{"count":1,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/posts\/11\/revisions"}],"predecessor-version":[{"id":503,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/posts\/11\/revisions\/503"}],"wp:attachment":[{"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}