[R] Accessing MySQL from Windows

[ripley@stats.ox.ac.uk]

On Fri, 31 May 2002, Luis Torgo wrote:

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

Yes, all you have to do is to compile it up for Windows.  You will need to
install MySQL for Windows and compile against the version you installed,
so it's not something which can be distributed.

You could have gone to CRAN and read the ReadMe in the bin/windows/contrib
directory ....

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

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