Problem when loading package RMySQL
It looks like you set MYSQL_HOME to point to a 64-bit MySQL, since C:\Program Files\ is for 64-bit software. For 32-bit R you need a 32-bit MySQL client (although you can use this with a 64-bit server).
On Sat, 21 Aug 2010, ... wrote:
Hello, I have a problem when loading RMySQL 0.7-5 on Windows 7 64 bit and with a 64-bit version of MySQL 5.1. My R version is 2.11.1 32-bit. I installed it from here: http://ftp.yalwa.org/cran/bin/windows/base/R-2.11.1-win32.exe I then installed RMySQL using a local zip file from here: http://cran.r-project.org/web/packages/RMySQL/index.html Windows binary: RMySQL_0.7-5.zip Here is the error:
library(RMySQL)
Error : .onLoad in loadNamespace() fehlgechlagen, Details: Aufruf: RMySQL Fehler: inDL(x, as.logical(local), as.logical(now), ...) Fehler: Laden von Paket/Namensraum f?r 'RMySQL' fehlgeschlagen My Path seems to be set correctly:
Sys.getenv("MYSQL_HOME")
MYSQL_HOME "C:\\Program Files\\MySQL\\MySQL Server 5.1" Any help would be appreciated! Cheers
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-db
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