{"id":257,"date":"2006-04-25T17:05:35","date_gmt":"2006-04-26T00:05:35","guid":{"rendered":"http:\/\/multimedia.cx\/eggs\/?p=257"},"modified":"2006-04-25T17:07:31","modified_gmt":"2006-04-26T00:07:31","slug":"mysql-disaster-recovery-works","status":"publish","type":"post","link":"https:\/\/multimedia.cx\/eggs\/mysql-disaster-recovery-works\/","title":{"rendered":"MySQL Disaster Recovery Works"},"content":{"rendered":"<p>I just want to briefly recognize <a href=\"http:\/\/www.mysql.com\/\">MySQL<\/a> for its resilience and robustness. Even in the event that a table gets corrupted, as happened today with the tables driving <a href=\"http:\/\/wiki.multimedia.cx\/\">the MultimediaWiki<\/a>, <em>&#8216;CHECK TABLE&#8217;<\/em> and <em>&#8216;REPAIR TABLE&#8217;<\/em> can diagnose and fix the problem and have your MySQL-backed application up and running in short order. Of course, I also have an automated script backing up the database tables off-site, every night, just for good measure.<\/p>\n<p><center><br \/>\n<a href=\"http:\/\/www.mysql.com\/\"><img decoding=\"async\" src=\"\/eggs\/images\/mysql-logo.gif\" alt=\"MySQL Logo\" \/><\/a><br \/>\n<\/center><\/p>\n<p>I just want any current or future contributors to be secure in the knowledge that the data is safe.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For those unexpected occasions&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-257","post","type-post","status-publish","format-standard","hentry","category-general"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/posts\/257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/comments?post=257"}],"version-history":[{"count":0,"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/posts\/257\/revisions"}],"wp:attachment":[{"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/media?parent=257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/categories?post=257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/multimedia.cx\/eggs\/wp-json\/wp\/v2\/tags?post=257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}