[R] RMySQL on Windows 2008 64 Bit -Help!
santosh.srinivas at gmail.com
Sat Nov 13 10:12:03 CET 2010
I could do that but will have to change all my code.
It would be great if I could get RMySQL on the 64 bit machine.
From: Ajay Ohri [mailto:ohri2007 at gmail.com]
Sent: 13 November 2010 14:13
To: Santosh Srinivas
Cc: r-help at r-project.org
Subject: Re: [R] RMySQL on Windows 2008 64 Bit -Help!
did you try the RODBC package as well.
On Sat, Nov 13, 2010 at 9:22 AM, Santosh Srinivas
<santosh.srinivas at gmail.com> wrote:
> Dear Group,
> I'm having lots of problems getting RMySQL on a 64 bit machine. I followed
> all instructions available but couldn't get it working yet! Please help.
> See the output below.
> I did a install of RMySQL binary from the revolution cran source. It seems
> to have unpacked fine but gives this error when I call RMySQL
> Error: package 'RMySQL' is not installed for 'arch=x64'
> I set this environment variable on the windows path
> "C:/Program Files/MySQL/MySQL Server 5.0"
> trying URL
> Content type 'application/x-gzip' length 160769 bytes (157 Kb)
> opened URL
> downloaded 157 Kb
> * installing *source* package 'RMySQL' ...
> checking for $MYSQL_HOME... C:/Program Files/MySQL/MySQL Server 5.0
> test: Files/MySQL/MySQL: unknown operand
> ERROR: configuration failed for package 'RMySQL'
> * removing 'C:/Revolution/Revo-4.0/RevoEnt64/R-2.11.1/library/RMySQL'
> * restoring previous
> The downloaded packages are in
> Warning message:
> In install.packages("RMySQL", type = "source") :
> installation of package 'RMySQL' had non-zero exit status
> R version 2.11.1 (2010-05-31)
>  LC_COLLATE=English_United States.1252 LC_CTYPE=English_United
> States.1252 LC_MONETARY=English_United States.1252 LC_NUMERIC=C
>  LC_TIME=English_United States.1252
> attached base packages:
>  stats graphics grDevices utils datasets methods base
> other attached packages:
>  Revobase_4.0.0 RevoScaleR_1.0-0 lattice_0.18-8
> loaded via a namespace (and not attached):
>  grid_2.11.1 tools_2.11.1
> R-help at r-project.org mailing list
> PLEASE do read the posting guide
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help