{"id":29,"date":"2006-04-05T07:39:12","date_gmt":"2006-04-05T11:39:12","guid":{"rendered":"http:\/\/www.thewormbook.com\/hlog\/?p=29"},"modified":"2006-04-05T07:39:12","modified_gmt":"2006-04-05T11:39:12","slug":"and-one-of-the-stupidsia","status":"publish","type":"post","link":"http:\/\/www.thewormbook.com\/hlog\/?p=29","title":{"rendered":"&#8230; and one of the stupidsia"},"content":{"rendered":"<p>Apparently the reason for the intermittent errors that people have been getting on this blog is that <a href=\"http:\/\/www.pair.com\">Pair<\/a> doesn&#8217;t like mySQL as a backend for MT blogs. Pair support suggests using sqlite instead, a database so fast and simple it is impossible for humans to use. MT support &#8212; who really aren&#8217;t much use &#8212; suggest exporting all the entries from one database and then reimporting them to a new installation. But that does nothing to transfer the templates, settings, plugins, and everything, in fact, that is not the plain text. There is <a href=\"http:\/\/as-is.net\/hacks\/2005\/07\/mt_db_convert_cgi_mt_database_converter.html\">a script<\/a> that is supposed to work this magic, but it doesn&#8217;t. The author clearly knows what he is doing but I have <a href=\"http:\/\/as-is.net\/blog\/tag\/SQLite\">a hard time understanding him<\/a> for reasons which may be clearer if you follow the link. So, unless anyone out there knows better, we&#8217;re stuck with intermittent database errors. Don&#8217;t all comment at once.<\/p>","protected":false},"excerpt":{"rendered":"<p>Apparently the reason for the intermittent errors that people have been getting on this blog is that Pair doesn&#8217;t like mySQL as a backend for MT blogs. Pair support suggests using sqlite instead, a database so fast and simple it &hellip; <a href=\"http:\/\/www.thewormbook.com\/hlog\/?p=29\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a> <a href=\"http:\/\/www.thewormbook.com\/hlog\/?p=29\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"_links":{"self":[{"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=\/wp\/v2\/posts\/29"}],"collection":[{"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=29"}],"version-history":[{"count":0,"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=\/wp\/v2\/posts\/29\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=29"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=29"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}