[R] Accessing MySQL from Windows

Luis Torgo ltorgo at liacc.up.pt
Fri May 31 19:54:28 CEST 2002


I'm using R on a Linux box:
> version           
platform i686-pc-linux-gnu
arch     i686             
os       linux-gnu        
system   i686, linux-gnu  
status                    
major    1                
minor    5.0              
year     2002             
month    04               
day      29               
language R    

I want to use data that is stored in a MySQL database.
I've been using the package RMySQL with sucess for this task.

I also use R from a Windows box
> version           
platform i386-pc-mingw32
arch     i386             
os       mingw32        
system   i386, mingw32  
status     Patched               
major    1                
minor    5.0              
year     2002             
month    05               
day      16               
language R

I wanted to use the same R code within this machine (thus using the 
RMySQL package). However, when using the Install from CRAN menu at Windows to 
pick the RMySQL package I cannot see it on the menu.... What am I doing 
wrong? According to the R Data Import/Export manual "Package RMySQL has been 
used on both Linux and Windows." ...

I'm able to get the data using RODBC and the myodbc driver, but I would 
prefer to have the same R code... Is this possible?

Thank you.    

-- 
Luis Torgo
    FEP/LIACC, University of Porto   Phone : (+351) 22 607 88 30
    Machine Learning Group           Fax   : (+351) 22 600 36 54
    R. Campo Alegre, 823             email : ltorgo at liacc.up.pt
    4150 PORTO   -  PORTUGAL         WWW   : http://www.liacc.up.pt/~ltorgo
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list