[R] Rmysql linking to an old-ish mysql build
Prof Brian Ripley
ripley at stats.ox.ac.uk
Sat May 9 19:17:41 CEST 2009
This topic is usually covered on R-sig-db, so its archives will give
more information (and as I recall, so would the R-help archives, not
least in pointing you to R-sig-db).
On Sat, 9 May 2009, Uwe Ligges wrote:
> Jose Quesada wrote:
>> I'm trying to get Rmysql to work o windows server 2008 64-bit.
>> I have the latest build of mysql installed (mysql-5.1.34-winx64).
> Independent of the version number of MySQL (which is less than 6 months old):
> If you are talking about the RMySQL binary build on CRAN: It is build against
> a 32-bit version of MySQL. I am not sure if there is a safe way to build a
> binary that properly links against 64-bit MySQL given you are running 32-bit
MySQL is a client-server system: this will work if you have a 32-bit
MySQL client DLL and arrange for RMySQL to find it (as a 32-bit client
can talk to a 64-bit server). That client DLL needs to be more or
less the same MySQL version as RMySQL was built against (and what
'more or less' means is determined by trial-and-error: there is no
guarantee whatsoever that any other version will work, and even single
patch-level differences have results in crashes).
> If there is, you have to install the package from sources yourself anyway.
That is in any case the safest thing to do.
> Uwe Ligges
>> When trying to load Rmysql, I got a warning that Rmysql is linking to an
>> old-ish mysql build (5.0.67).
>> I could do some basic stuff (the connection works) but it breaks when
>> trying to read a large table.
>> So I set up to use the buld 5.0.67 that Rmysql likes.
>> 10 hrs later and after lots of sysadmin work, I have to call it quits. I
>> couldn't make it work.
>> Since this mysql 5.0.67 is pretty old, I was wondering if anyone has
>> binaries for Rmysql that work for a more recent version.
>> Maybe the authors of the package have plans to update it soon?
>> I've tried the package on both R 2.9.0 and R2.8.1.
>> If nothing comes up, I'll try to spend a few more hours on getting the
>> old version to work.
> R-help at r-project.org mailing list
> 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
More information about the R-help