{"id":33,"date":"2006-04-09T16:30:27","date_gmt":"2006-04-09T20:30:27","guid":{"rendered":"http:\/\/www.thewormbook.com\/hlog\/?p=33"},"modified":"2006-04-09T16:30:27","modified_gmt":"2006-04-09T20:30:27","slug":"dear-nerdworld","status":"publish","type":"post","link":"http:\/\/www.thewormbook.com\/hlog\/?p=33","title":{"rendered":"Dear nerdworld"},"content":{"rendered":"

Is there any way to convert a sizable MySQL database containing this blog to sqlite? Here are some of the ways that don’t work:<\/p>\n\n\n

    \n
  1. Using the mt-db-convert.cgi script:<\/a> this ought to work, but is killed by the reaper at Pair. After exchanging around ten emails with the genuinely helpful and friendly support there, and then spending half an hour on the phone to Pittsburgh, we established that even when the scipt runs to a conclusion, it crashes with incomprehensible error messages.<\/li>\n
  2. Using MySQLdump to get a listing of the database and then reading that into the SQL<\/span>ite database browser,<\/a> which is supposed to understand this things. It claims there is “an error at line 2013051320”. There is, of course, no such line.<\/li>\n
  3. Using the SQL<\/span>-Fairy<\/a> set of Perl modules. They come highly recommended, take no more than half a day to install on a fast machine. Feed them a 6MB SQL <\/span>file and they die at line 18, the first one that starts “CREATE TABLE<\/span>“, protesting that it does not start with “create”.<\/li>\n
  4. I have not yet tried finding the authors of all or any of these programs; cutting their throats over my keyboard and then typing fast while my fingers splash in hot blood, but as soon as I get the chance, I will. I’m pretty certain that no lesser sacrifice will work.<\/li>\n<\/ol>\n\n\n\n

    In the meantime, if you find your comment won’t post, I apologise. I have done my best.<\/p>","protected":false},"excerpt":{"rendered":"

    Is there any way to convert a sizable MySQL database containing this blog to sqlite? Here are some of the ways that don’t work: Using the mt-db-convert.cgi script: this ought to work, but is killed by the reaper at Pair. … Continue reading →<\/span><\/a> Continue reading →<\/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\/33"}],"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=33"}],"version-history":[{"count":0,"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=\/wp\/v2\/posts\/33\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.thewormbook.com\/hlog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}