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@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, rip...@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
______________________________________________
R-help@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.
