[R] Problems with RMySQL and MySQL server version 5.1

[Jeffrey Horner]

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