Greatest Webhost On The Interweb: pair.com

So it's the end of the Memorial day weekend, and I decide to take a look at the trouble I found had cropped up on Friday... My movable type comments were corrupt, and I had something like 70,000 junk comments. so anyway it was too much for MySQL and the database table was corrupt for mt_comments. I wasn't too worried because I knew this was a static site so I wouldn't be offline completely. But it was a nagging problem I knew needed fixed.

I opened a ticket with pair.com Monday morning around 10am to see if they could help, and within an hour the problem was fixed! Is that service or what?

Thanks go out to Kevin O. for his prompt service, and dedication on a holiday! He went ahead and repaired the comments table to resolve my problem. Now I'm not a MySQL expert by any stretch and having a host that would provide this assistance at the drop of a hat is just great. My next big project is going to use a lot of MySQL so probably this won't happen again, but the help was greatly appreciated.

Pair.com

These were useful in clearing out the junk comments:


show columns from mt_comment;
delete from mt_comment where comment_junk_status < 0;
delete from mt_comment where comment_author like "%loan%";