#43: resetting Rails schema_migrations table

I just ran a failing migration, and in a fit of panic, deleted all the rows from my schema migrations table. That's a pretty dumb thing to do.

#34: Indexing the results of an nested set ancestry query

I would like to use Sphinx and ThinkingSphinx to index the results of a nested set ancestry query, but I'm not entire sure how. The kind of query I need to do would be something like SELECT id FROM taxa WHERE taxa.lft <= $target_taxon_lft AND taxa.rgt...

#26: Switch a MySQL table charset to UTF8

I would like to switch a MySQL table or database to the UTF-8 character set, after it has already been created as Latin1.