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.
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...
I would like to switch a MySQL table or database to the UTF-8 character set, after it has already been created as Latin1.