{"id":1130,"date":"2005-08-05T04:37:34","date_gmt":"2005-08-04T19:37:34","guid":{"rendered":"http:\/\/unknowngenius.com\/blog\/?p=1130"},"modified":"2005-08-05T17:08:48","modified_gmt":"2005-08-05T08:08:48","slug":"a-million-bytes-cried-out-in-terror","status":"publish","type":"post","link":"https:\/\/unknowngenius.com\/blog\/archives\/2005\/08\/05\/a-million-bytes-cried-out-in-terror\/","title":{"rendered":"As if a million bytes cried out in terror and were suddenly silenced."},"content":{"rendered":"<p>A pretty bad week for databases.<\/p>\n<p> After nearly killing a client&#8217;s DB yesterday (and spending most of my night restoring every bits and pieces semi-manually), I felt it wise to secure my own DB here. The one that stores this blog. Guess what happened then? <\/p>\n<p>Yea, I blew the DB too. Or to be more precise: <em>mySQL<\/em> blew the part of the DB encoded in Japanese.<\/p>\n<p>Here again I just spent half my night recovering everything that could be. Unfortunately all Japanese content for entries posted in June and early July is lost for good: not like it had much literary value, but still a bummer. And in case you are wondering about backups: believe me, I have backups, hundred of them&#8230; It just turns out that this piece of crap SQL isn&#8217;t even able to properly back up an exact binary copy of your tables that won&#8217;t screw up when it encounters encodings it can&#8217;t handle properly. So every single backup I have, is identically screwed.<\/p>\n<p>My last personal piece of advice to any mySQL user out there, is to stay away from <i>mysqldump<\/i> do a freaking binary copy of the db files directly.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A pretty bad week for databases. After nearly killing a client&#8217;s DB yesterday (and spending most of my night restoring every bits and pieces semi-manually), I felt it wise to secure my own DB here. The one that stores this blog. Guess what happened then? Yea, I blew the DB too. Or to be more [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":4,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":""},"categories":[1,31,25],"tags":[],"class_list":["post-1130","post","type-post","status-publish","format-standard","hentry","category-geek","category-meta","category-25"],"_links":{"self":[{"href":"https:\/\/unknowngenius.com\/blog\/wp-json\/wp\/v2\/posts\/1130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknowngenius.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknowngenius.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknowngenius.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/unknowngenius.com\/blog\/wp-json\/wp\/v2\/comments?post=1130"}],"version-history":[{"count":0,"href":"https:\/\/unknowngenius.com\/blog\/wp-json\/wp\/v2\/posts\/1130\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknowngenius.com\/blog\/wp-json\/wp\/v2\/media?parent=1130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknowngenius.com\/blog\/wp-json\/wp\/v2\/categories?post=1130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknowngenius.com\/blog\/wp-json\/wp\/v2\/tags?post=1130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}