{"id":3192,"date":"2002-07-26T07:29:12","date_gmt":"2002-07-26T12:29:12","guid":{"rendered":"http:\/\/hill-kleerup.org\/blog\/wp\/?p=3192"},"modified":"2002-07-26T07:29:12","modified_gmt":"2002-07-26T12:29:12","slug":"mt_and_mysql","status":"publish","type":"post","link":"https:\/\/hill-kleerup.org\/blog\/2002\/07\/26\/mt_and_mysql.html","title":{"rendered":"MT and MySQL"},"content":{"rendered":"

If you’re upgrading to MT 2.2 and going with the MySQL conversion option (which I think you should, just on principle), Scriptygoddess has a nice tutorial on setting up your MySQL database<\/a> for it.<\/p>\n

Since it took me a couple of tries to figure it out, I think it’s worth reading. The MT documentation is decent enough to puzzle it out, but this short tutorial makes it even easier.<\/p>\n

UPDATE<\/u>: While you’re at it, you might check out their upgraded Expand\/Collapse code <\/a>for posts and comments. I’ve considered implementing it here, but haven’t decided it if would be a good thing or not.<\/p>\n","protected":false},"excerpt":{"rendered":"

If you’re upgrading to MT 2.2 and going with the MySQL conversion option (which I think you should, just on principle), Scriptygoddess has a nice tutorial on setting up your…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":0,"_seopress_analysis_target_kw":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[],"class_list":["post-3192","post","type-post","status-publish","format-standard","hentry","category-blogging"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":5535,"url":"https:\/\/hill-kleerup.org\/blog\/2004\/02\/25\/stylish_2.html","url_meta":{"origin":3192,"position":0},"title":"Stylish","author":"***Dave","date":"Wed 25-Feb-04 7:55am","format":false,"excerpt":"A fine site called Movable Styles has some great plug-and-play MT style sheets to test out (see the selection box in the side bar). I see many inspirations a-coming; I've...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2416,"url":"https:\/\/hill-kleerup.org\/blog\/2002\/06\/27\/oh_swell.html","url_meta":{"origin":3192,"position":1},"title":"Oh, swell","author":"***Dave","date":"Thu 27-Jun-02 10:54am","format":false,"excerpt":"MovableType 2.2 is now out. I had other plans for Friday night, but it looks like I'll be doing an upgrade instead. It looks like it uses MySQL databases, which...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5673,"url":"https:\/\/hill-kleerup.org\/blog\/2004\/01\/27\/in_the_blacklis.html","url_meta":{"origin":3192,"position":2},"title":"In the Blacklist","author":"***Dave","date":"Tue 27-Jan-04 9:38am","format":false,"excerpt":"As inspired by ScriptyGoddess (who gets lots of comment spam), I'm offering access to my own blacklist that I use with MT-Blacklist; it includes both the canonical list, ones I've...","rel":"","context":"In "Spam"","block_context":{"text":"Spam","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/computer-security\/spam"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3157,"url":"https:\/\/hill-kleerup.org\/blog\/2002\/07\/31\/more_more_more.html","url_meta":{"origin":3192,"position":3},"title":"More! More! More!","author":"***Dave","date":"Wed 31-Jul-02 12:56pm","format":false,"excerpt":"Props for this cool MT hack to the ladies at Scriptygoddess (for writing\/modifying) and to Doyce (for debugging for this blogging nitwit)....","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2407,"url":"https:\/\/hill-kleerup.org\/blog\/2002\/06\/28\/under_construct.html","url_meta":{"origin":3192,"position":4},"title":"UNDER CONSTRUCTION","author":"***Dave","date":"Fri 28-Jun-02 6:27pm","format":false,"excerpt":"I'm going to be upgrading to MovableType 2.2 this evening, doing a backup first and all. There's a finite chance the database could get zorched, so if you post something...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":375,"url":"https:\/\/hill-kleerup.org\/blog\/2003\/04\/25\/some_sort_of_an.html","url_meta":{"origin":3192,"position":5},"title":"Some sort of an echo in here …","author":"***Dave","date":"Fri 25-Apr-03 8:10pm","format":false,"excerpt":"By and large, I've eschewed MT hacks. Not plug-ins, 'cause that's cool. But things that require me to go in and modify the MT code, and therefore repeat the mods...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts\/3192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/comments?post=3192"}],"version-history":[{"count":0,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts\/3192\/revisions"}],"wp:attachment":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/media?parent=3192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/categories?post=3192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/tags?post=3192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}