[R] RMySQL on win32

[Uwe Ligges]

Pete Cap wrote:
> List,
> 
> I just left an environment where I was running R and mysql on CENTOS.
> At the time of install, RMySQL was available on CRAN.  Later installs
> on Ubuntu were possible because it was available as a package in the
> base repos.
> 
> Now I'm in a new environment where I have no choice but to use
> Windows XP.  I have just installed R 2.4.1 and MySQL 5.0.27.  The
> installation instructions for getting RMySQL to install are a bit
> dense and possibly over my head, so I'm wondering if it is really
> necessary to compile the package against my current versions (yes, I
> realize that may be a question with a painfully obvious answer), or
> if I can simply use one of the precompiled binaries at David James's
> site.  If anyone can tell me (or if there is a very easy way to get
> RMySQL up and running on win32), please let me know.
> 
> As an aside, can anyone explain why it is not possible to keep that
> package in CRAN?  I'm just curious about that, it's just for my own
> enlightenment.

For CRAN, I could only build against one version of MySQL for each 
version of R. In the past (particularly up to R-1.6.x), Brian Ripley 
made some bad experiences with incompatibilities when the package was 
built using different versions of MySQL. Hence we do not want to provide 
builds to the public that might only work together with some particular 
versions of MySQL.

Best,
Uwe




> 
> Thanks,
> 
> Pete
> 
> 
> --------------------------------- Don't get soaked.  Take a quick
> peek at the forecast
> 
> [[alternative HTML version deleted]]
> 
> ______________________________________________ 
> R-help at stat.math.ethz.ch mailing list 
> https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the
> posting guide http://www.R-project.org/posting-guide.html and provide
> commented, minimal, self-contained, reproducible code.