Skip to content

Rmysql linking to an old-ish mysql build

3 messages · Jose Quesada, Uwe Ligges, Brian Ripley

Jose Quesada
# 
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).

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
Uwe Ligges
#
Jose Quesada wrote:
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.
If there is, you have to install the package from sources yourself anyway.

Best,
Uwe Ligges
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:

            

      
      
      
    

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

            

      
      
      
    

        
That is in any case the safest thing to do.