[R] Rmysql linking to an old-ish mysql build

[Prof Brian Ripley]

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:
>> Hi,
>> 
>> 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 
> R.

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.

> Best,
> 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.
>> 
>> Thanks!
>> 
>> Best,
>> -Jose
>> 
>
> ______________________________________________
> R-help at r-project.org 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