Rmysql linking to an old-ish mysql build
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. If there is, you have to install the package from sources yourself anyway. 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