[R-SIG-Mac] brief RMySQL walkthrough

[Simon Urbanek]

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
>>
>>
>