{"id":6235,"date":"2015-03-19T08:51:41","date_gmt":"2015-03-19T12:51:41","guid":{"rendered":"http:\/\/starlightcascade.ca\/blog\/?p=6235"},"modified":"2015-03-19T08:51:41","modified_gmt":"2015-03-19T12:51:41","slug":"crash-recovery","status":"publish","type":"post","link":"https:\/\/starlightcascade.ca\/blog\/2015\/03\/crash-recovery\/","title":{"rendered":"crash recovery"},"content":{"rendered":"<p><a href=\"http:\/\/starlightcascade.ca\/blog\/wp-content\/uploads\/2014\/06\/seagate-green-top.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/starlightcascade.ca\/blog\/wp-content\/uploads\/2014\/06\/seagate-green-top-299x278.jpg\" alt=\"seagate-green-top\" width=\"299\" height=\"278\" class=\"alignright size-medium wp-image-5735\" srcset=\"https:\/\/starlightcascade.ca\/blog\/wp-content\/uploads\/2014\/06\/seagate-green-top-299x278.jpg 299w, https:\/\/starlightcascade.ca\/blog\/wp-content\/uploads\/2014\/06\/seagate-green-top-150x139.jpg 150w, https:\/\/starlightcascade.ca\/blog\/wp-content\/uploads\/2014\/06\/seagate-green-top.jpg 600w\" sizes=\"auto, (max-width: 299px) 100vw, 299px\" \/><\/a><br \/>\nOur server had a power supply fail, taking with it many sectors of the 320GB SATA hard drive.  The bad sectors contained a lot of the mysql database.<br \/>\nLuckily we had a week old backup of the database and it restored ok.  Unfortunately other databases did not fare so well and we are still forced to run under a limping mode  innodb_force_recovery = 2 inside of \/etc\/my.cnf  Now we try to identify bad tables and remove them to get the database server to run again.<\/p>\n<p>In the meantime we are learning far more about databases then we would like to, yet not enough to easily identify and fix the problem.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Our server had a power supply fail, taking with it many sectors of the 320GB SATA hard drive. The bad sectors contained a lot of the mysql database. Luckily we had a week old backup of the database and it restored ok. Unfortunately other databases did not fare so well and we are still forced [&hellip;]<\/p>\n","protected":false},"author":494,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-6235","post","type-post","status-publish","format-standard","hentry","category-tech"],"_links":{"self":[{"href":"https:\/\/starlightcascade.ca\/blog\/wp-json\/wp\/v2\/posts\/6235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/starlightcascade.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/starlightcascade.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/starlightcascade.ca\/blog\/wp-json\/wp\/v2\/users\/494"}],"replies":[{"embeddable":true,"href":"https:\/\/starlightcascade.ca\/blog\/wp-json\/wp\/v2\/comments?post=6235"}],"version-history":[{"count":1,"href":"https:\/\/starlightcascade.ca\/blog\/wp-json\/wp\/v2\/posts\/6235\/revisions"}],"predecessor-version":[{"id":6236,"href":"https:\/\/starlightcascade.ca\/blog\/wp-json\/wp\/v2\/posts\/6235\/revisions\/6236"}],"wp:attachment":[{"href":"https:\/\/starlightcascade.ca\/blog\/wp-json\/wp\/v2\/media?parent=6235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/starlightcascade.ca\/blog\/wp-json\/wp\/v2\/categories?post=6235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/starlightcascade.ca\/blog\/wp-json\/wp\/v2\/tags?post=6235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}