Message-ID: <alpine.LFD.2.00.1008211645450.11719@gannet.stats.ox.ac.uk>
Date: 2010-08-21T17:04:31Z
From: Brian Ripley
Subject: Problem when loading package RMySQL
In-Reply-To: <AANLkTin3npu1DmuPJOof+TcMiSmpCt1TQT8_+6_mvu0m@mail.gmail.com>
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