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 <rip...@stats.ox.ac.uk>
To: Jeffrey Horner <jeff.hor...@vanderbilt.edu>
CC: r-sig...@stat.math.ethz.ch
References: <4964cd3d.9000...@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.jorgen...@agrsci.dk>
To: jeff.hor...@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, 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
--
http://biostat.mc.vanderbilt.edu/JeffreyHorner
______________________________________________
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.
