64-bit RMySQL on Mac OS X 10.6

There are currently problems with the pre-compiled binary of RMySQL for the 64bit version of R on macs. To get round this you have to download the source and run the following command:

R CMD INSTALL --configure-args='--with-mysql-dir=/usr/local/mysql --with-mysql-inc=/usr/local/mysql/include --with-mysql-lib=/usr/local/mysql/lib' RMySQL_0.7-4.tar.gz

This is based on a post at Andrew's musings