Skip to content

brief RMySQL walkthrough

3 messages · Kyle Matoba, Simon Urbanek

Original
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
Simon Urbanek
# 
Kyle,

is there a particular reason why to not use a much simpler
install.packages("RMySQL")

You don't need any of the stuff below to use it ...

Cheers,
Simon
On Mar 25, 2010, at 14:18 , Kyle Matoba wrote:

            

      
      
      
    

        

      
      
    

  
  


  


      

    

    

      
      

        


  

        

      Simon Urbanek
    

    

      
      #
    

  


  

      
On Mar 25, 2010, at 14:25 , Simon Urbanek wrote:

        

            

      
      
      
    

        
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