[R] How to install RMySQL package in R 2.5 in Windows OS?

[Prof Brian Ripley]

I can confirm problems with the current mysql 5.0.41: I get

> library(RMySQL)
Loading required package: DBI
Error in dyn.load(x, as.logical(local), as.logical(now)) :
         unable to load shared library 
'd:/R/library/RMySQL/libs/RMySQL.dll':
   LoadLibrary failure:  Invalid access to memory location.

I do have a successful build with 5.0.21 (the version I have been testing 
RODBC against), and have put that on my repository so it will 
automatically be available to Windows users.

The mysql 5.0.41 problem occurs equally with that pre-built RMySQL binary 
and with a build from the sources.

My Linux box is running 5.0.27, and RMySQL works there.

On Wed, 13 Jun 2007, Joe W. Byers wrote:

> Prof Brian Ripley wrote:
>> On Wed, 13 Jun 2007, Ruixin ZHU wrote:
>> 
>>> Dear R-users,
>>> 
>>> It seems that install.packages( ) doesn't work to RMySQL package.
>> 
>> Under Windows, yes.  You need the MySQL client libraries for your version 
>> of MySQL (or something very close to the same version), so the only safe 
>> way is to install from the sources.  The latter is not hard and there are 
>> instructions in the package.
> There are several of us working on updating the RMySQL binary for windows. 
> Currently one has it compiled with mysql 5.0.18, but can't get it to compile 
> with 5.0.41.  I am having trouble with 5.0.22,  5.0.24, and 5.0.37 mysql 
> binaries.  There seems to be some problems with different versions of mysql. 
> As soon as we have a tested version of the windows binary for RMySQL, 
> information for obtaining it will be posted.
>
> We all appreciate you patiences.
>
> Thank you
> Joe
>
>
>> 
>> 
>>> Would anybody have the experience of that?
>>> 
>>> Thanks
>>> _____________________________________________
>>> Dr.Ruixin ZHU
>>> Shanghai Center for Bioinformation Technology
>>> rxzhu at scbit.org
>>> zhurx at mail.sioc.ac.cn
>>> 86-21-13040647832
>>> 
>>>
>>>  [[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.
>>> 
>> 
>

-- 
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 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595