Problems with RMySQL and MySQL server version 5.1
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