Had to switch to the 64-bit version of MySQL. Then I needed to re-install the MySQL gem as follows:For Sphinx, I had to compile with the following commands:Check out this website for more info.
env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
LDFLAGS="-arch x86_64" ./configure --prefix=/usr/local --with-mysql=/usr/local/mysql make sudo make install
Update: Use the 32-bit version of MySQL if you’re still on Leopard. Apparently the Ruby interpreter is 32-bit on Leopard and 64-bit on Snow Leopard. Grr.