Argh. So I was working with my database this morning, and I accidentally did an update comments set date='blah'; and very notably left off the where cid=d clause. So it said it updated thousands of records, I cursed, and I immediately typed rollback; to which mysql replied:
ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back
I cursed again, and reminded myself "No problem, that's why I keep nightly database backups."
Only when I looked, it turns out I was never backing up the comments table. So now I'm in limbo waiting for dreamhost to reply and let me know if they actually make backups and can give me a copy of the table... If they can't, I'm going to have to have to get very personal with the google cache of Linkstew...
So, for now, this means that if you're looking at old entries, all of the dates for the comments aren't just going to be wrong, they're all going to be the same. Blah. Talk about a bad way to start a day.
update: Okay, they restored the table from backup for me, even though I asked them to give me a copy of the dump so I could restore it myself... Unfortunately, this means if you left a comment between 2003-04-28 22:52:18 and 2003-04-30 16:00ish, it was lost. That was at least one comment that I know of... Blah. Oh well. It's not like I'm that popular or anything. =)