Rmysql linking to an old-ish mysql build
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