brief RMySQL walkthrough
On Mar 25, 2010, at 14:25 , Simon Urbanek wrote:
Kyle,
is there a particular reason why to not use a much simpler
install.packages("RMySQL")
I think I can now answer that question -- the CRAN machine did not have 64-bit Intel binaries of MySQL, so the x86_64 architecture of the CRAN binary did not work (i386 and ppc did work). It is fixed now. (Lesson: please report such issues instead of hacking around them!) Thanks, Simon
You don't need any of the stuff below to use it ... Cheers, Simon On Mar 25, 2010, at 14:18 , Kyle Matoba wrote:
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
_______________________________________________ R-SIG-Mac mailing list R-SIG-Mac at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-mac