Jeffrey Horner
2009-Jan-12 21:04 UTC
[R] Problems with RMySQL and MySQL server version 5.1
For those R user's who don't subscribe to R-sig-db and are having troubles with the latest RMySQL binary on CRAN, please read the email thread at the end of this message. RMySQL 0.7-2 does work with MySQL 5.1, however the CRAN binary is linked against the 5.0 version. Best, Jeff -------- Original Message -------- Subject: Re: [R-sig-DB] Problems with RMySQL and MySQL server version 5.1 Date: Wed, 07 Jan 2009 16:36:48 +0000 From: Prof Brian Ripley <ripley at stats.ox.ac.uk> To: Jeffrey Horner <jeff.horner at vanderbilt.edu> CC: r-sig-db at stat.math.ethz.ch References: <4964CD3D.9000705 at vanderbilt.edu> There is a long, long history of precisely this (version mismatches in MySQL binaries cause crashes). We had it at 4.x, so I am not surprised to see it at 5.x now 'x' is no longer unique. When I distributed binaries, the README on my site pointed this out: I suggest you ask Uwe to put it in his README, and if possible do a version check at run time. Jeffrey Horner wrote:> An FYI to those users having problems with windows RMySQL CRAN binaries. > > -------- Original Message -------- > Subject: Problems with RMySQL and MySQL server version 5.1 > Date: Wed, 7 Jan 2009 09:12:56 +0100 > From: Erik J?rgensen <Erik.Jorgensen at agrsci.dk> > To: jeff.horner at vanderbilt.edu > > Hi Jeffrey > > I have some problems with the use of RMySQL since upgrading to RMySQL > version 0.7-2 and MySQL server version 5.1. The RGUI crashes, when I > e.g. call the function dbGetQuery(conn, sqlstring) (but not e.g. > dbListTables(conn)). > > It seems that it is due to incompatibility with MySQL version 5.1. > When I replace the libMySQL.dll file from version 5.1 with the 5.0 > version of the file, the problem disappears. > > Best regards > > Erik J?rgensen > Faculty of Agricultural Sciences, > Aarhus University, > Denmark > > PS. R - version 2.8.1 - Windows XP Professional Service Pack3. I > specify the path to the DLL-file manually via the environment > variable MYSQL_HOME. >-- 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 -- http://biostat.mc.vanderbilt.edu/JeffreyHorner