[R-sig-DB] Problem when loading package RMySQL

[Prof Brian Ripley]

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 using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>

-- 
Brian D. Ripley,                  ripley using 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