{"id":915,"date":"2004-11-12T12:55:50","date_gmt":"2004-11-12T12:55:50","guid":{"rendered":"http:\/\/www.geoffreylong.com\/wordpress\/?p=915"},"modified":"2004-11-12T12:55:50","modified_gmt":"2004-11-12T12:55:50","slug":"im-feeling-those-good-migrations","status":"publish","type":"post","link":"http:\/\/www.geoffreylong.com\/wordpress\/archives\/915","title":{"rendered":"I’m feeling those good migrations."},"content":{"rendered":"

So, I did it. I downloaded the archive of Tip of the Quill<\/i> and cleaned out the spam comments. I probably didn’t get all<\/i> of them, but nearly all of the 25,000+ spam comments are now gone, which shrank a 23MB file to a 1.4MB file. Now all I have to do is recreate the TOTQ templates using the new MT3 features and I’ll be all set. This will probably happen sometime this weekend (if I can finish up a couple other high-priority projects first) or sometime next week.
\nUntil then, any comments made will be living on borrowed time; they probably won’t show up in the new edition, unless I do a little fancy tap-dancing with a secondary import (which I suppose I could do, if there are a ton of new comments). Regardless, that’s a huge amount of progress, and I can’t wait until this is all cleaned up and rolling again!
\nOh, and just a reminder for my regular readers and commenters: you’re going to need a TypeKey account<\/A> to comment here in the future. It’s free, it’s easy, and it’ll prevent me from ever spending 12 hours deleting spam comments again. I really hope the extra step won’t prevent you from joining me in the next generation of this weblog — I love hearing what you have to say, which is why I’m taking the time to rework the way comments function here, instead of turning them off permanently. Stay tuned.
\nUpdate.<\/b> Hah! Between the holidays, client projects and a bunch of other hijinks, it was February 2005<\/i> before the migration was finished, but now the new version’s up and running at last. Progress!<\/p>\n","protected":false},"excerpt":{"rendered":"

So, I did it. I downloaded the archive of Tip of the Quill and cleaned out the spam comments. I probably didn’t get all of them, but nearly all of the 25,000+ spam comments are now gone, which shrank a 23MB file to a 1.4MB file. Now all I have to do is recreate the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-915","post","type-post","status-publish","format-standard","hentry","category-voice-tip-of-the-quill"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4e5QR-eL","jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/www.geoffreylong.com\/wordpress\/wp-json\/wp\/v2\/posts\/915","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.geoffreylong.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.geoffreylong.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.geoffreylong.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.geoffreylong.com\/wordpress\/wp-json\/wp\/v2\/comments?post=915"}],"version-history":[{"count":0,"href":"http:\/\/www.geoffreylong.com\/wordpress\/wp-json\/wp\/v2\/posts\/915\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.geoffreylong.com\/wordpress\/wp-json\/wp\/v2\/media?parent=915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.geoffreylong.com\/wordpress\/wp-json\/wp\/v2\/categories?post=915"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.geoffreylong.com\/wordpress\/wp-json\/wp\/v2\/tags?post=915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}