[R] Problems with RMySQL and MySQL server version 5.1
jeff.horner at vanderbilt.edu
Mon Jan 12 22:04:07 CET 2009
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.
-------- 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.
> 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,
> 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
More information about the R-help