[R-SIG-Mac] brief RMySQL walkthrough

[Kyle Matoba]

All,

Here are the steps I went through to install RMySQL on Snow Leopard
this morning ( March 25, 2010 ):

Download and install mySQL: http://dev.mysql.com/downloads/mysql/
(MySQL Community Server 5.1.45)
Download the client libraries:
http://dev.mysql.com/downloads/connector/c/ (Connector/C 6.0.2)
Obtain the source: http://cran.r-project.org/src/contrib/RMySQL_0.7-4.tar.gz
Unpack the source (in finder, e.g.)
Unpack the client libraries, copy the /include and /lib directories
into the corresponding in /usr/local/mysql/ or wherever you installed
mySQL.
Compile the source:

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'
 ~/Downloads/RMySQL_0.7-4.tar

Do not know if this is the most concise way of going about it, but it
worked for me.  For further reading I recommend Jeff's exchange of
April 30, 2009.

Regards,

Kyle