{"id":864,"date":"2003-01-14T16:47:29","date_gmt":"2003-01-15T08:47:29","guid":{"rendered":"http:\/\/michaelhans.com\/eclecticism\/2003\/01\/15\/switch-to-mysql\/"},"modified":"2019-12-04T11:33:40","modified_gmt":"2019-12-04T19:33:40","slug":"switch-to-mysql","status":"publish","type":"post","link":"https:\/\/michaelhans.com\/eclecticism\/2003\/01\/14\/switch-to-mysql\/","title":{"rendered":"Switch to MySQL"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:15477,&quot;href&quot;:&quot;http:\\\/\\\/www.movabletype.org\\\/cgi-bin\\\/ikonboard\\\/ikonboard.cgi?s=3e251cde2077ffff;act=ST;f=19;t=12947;st=0&quot;,&quot;archived_href&quot;:&quot;&quot;,&quot;redirect_href&quot;:&quot;https:\\\/\\\/movabletype.org\\\/cgi-bin\\\/ikonboard\\\/ikonboard.cgi?s=3e251cde2077ffff;act=ST;f=19;t=12947;st=0&quot;,&quot;checks&quot;:[],&quot;broken&quot;:false,&quot;last_checked&quot;:null,&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:7289,&quot;href&quot;:&quot;http:\\\/\\\/www.movabletype.org&quot;,&quot;archived_href&quot;:&quot;https:\\\/\\\/web-wp.archive.org\\\/web\\\/20260306004502\\\/https:\\\/\\\/movabletype.org\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2026-03-09 20:10:06&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-15 05:52:16&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-24 17:25:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-28 03:37:19&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-31 10:45:45&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-03 16:49:20&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-07 00:00:33&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-10 05:19:44&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-13 07:08:16&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-16 07:33:11&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-04-16 07:33:11&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:15478,&quot;href&quot;:&quot;http:\\\/\\\/www.mysql.com&quot;,&quot;archived_href&quot;:&quot;https:\\\/\\\/web-wp.archive.org\\\/web\\\/20260311084020\\\/https:\\\/\\\/www.mysql.com\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2026-03-13 19:12:05&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-03-27 06:09:21&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-04-07 09:50:15&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-04-15 11:05:51&quot;,&quot;http_code&quot;:403}],&quot;broken&quot;:true,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-04-15 11:05:51&quot;,&quot;http_code&quot;:403},&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:15479,&quot;href&quot;:&quot;http:\\\/\\\/www.movabletype.org\\\/cgi-bin\\\/ikonboard\\\/ikonboard.cgi?s=3e251f3d219effff;act=ST;f=7;t=12235&quot;,&quot;archived_href&quot;:&quot;&quot;,&quot;redirect_href&quot;:&quot;https:\\\/\\\/movabletype.org\\\/cgi-bin\\\/ikonboard\\\/ikonboard.cgi?s=3e251f3d219effff;act=ST;f=7;t=12235&quot;,&quot;checks&quot;:[],&quot;broken&quot;:false,&quot;last_checked&quot;:null,&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p>After <a href=\"http:\/\/www.movabletype.org\/cgi-bin\/ikonboard\/ikonboard.cgi?s=3e251cde2077ffff;act=ST;f=19;t=12947;st=0\" title=\"Attempting to convert to sql...\">struggling with things<\/a> for a few hours tonight, I&#8217;ve managed to succesfully convert the database backend for <a href=\"http:\/\/www.movabletype.org\/\" title=\"MovableType\">MovableType<\/a> to <a href=\"http:\/\/www.mysql.com\/\" title=\"The world's most popular open-source database\">MySQL<\/a>.<\/p>\n<p>What does this mean? Well&#8230;good question. For you, the end-user, not much, though as MySQL is supposed to be a bit faster, posting comments might be a bit more responsive than it was before. For me as the author\/administrator, it should mean a bit more speed when creating\/editing entries, and a lot more options as far as what I can do on a design\/implementation level.<\/p>\n<p>At least, that&#8217;s the theory. If nothing else, according to one of the moderators of the MovableType Support Forums, &#8220;If you have the choice, <a href=\"http:\/\/www.movabletype.org\/cgi-bin\/ikonboard\/ikonboard.cgi?s=3e251f3d219effff;act=ST;f=7;t=12235\" title=\"DB or MySQL?\">pick mysql<\/a>. :) A little faster, more stable, easy to browse the database&#8230;.&#8221; Good enough for me!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After struggling with things for a few hours tonight, I&#8217;ve managed to succesfully convert the database backend for MovableType to MySQL.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2040],"tags":[812],"class_list":["post-864","post","type-post","status-publish","format-standard","hentry","category-blog","tag-movabletype"],"_links":{"self":[{"href":"https:\/\/michaelhans.com\/eclecticism\/wp-json\/wp\/v2\/posts\/864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/michaelhans.com\/eclecticism\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/michaelhans.com\/eclecticism\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/michaelhans.com\/eclecticism\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/michaelhans.com\/eclecticism\/wp-json\/wp\/v2\/comments?post=864"}],"version-history":[{"count":0,"href":"https:\/\/michaelhans.com\/eclecticism\/wp-json\/wp\/v2\/posts\/864\/revisions"}],"wp:attachment":[{"href":"https:\/\/michaelhans.com\/eclecticism\/wp-json\/wp\/v2\/media?parent=864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/michaelhans.com\/eclecticism\/wp-json\/wp\/v2\/categories?post=864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/michaelhans.com\/eclecticism\/wp-json\/wp\/v2\/tags?post=864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}