Well, two comments:
1. you bought a commercial version of R from Revolution Analytics, hence
you probably want to rely on the Revolution service?
2. Nobody looked at the error message you got, let me cite the relevant
two lines:
>>> checking for $MYSQL_HOME... C:/Program Files/MySQL/MySQL Server 5.0
>>> test: Files/MySQL/MySQL: unknown operand
This shows you have problems with the blanks in the path name.
Either you forgot to quote the path when setting the environment
variable or RMySQL the package maintainer has not assumed blanks in the
path.
I'd suggest to quote or to use thew 8.3 file name convention in order to
workaround.
Best,
Uwe Ligges
On 13.11.2010 14:52, Spencer Graves wrote:
Hello:
I suggest try R-SIG-DB email list. They focus specifically on databases,
and you might get a better response there.
Sorry I can't help more.
Spencer
On 11/13/2010 1:12 AM, Santosh Srinivas wrote:
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.
-----Original Message-----
From: Ajay Ohri [mailto:ohri2...@gmail.com]
Sent: 13 November 2010 14:13
To: Santosh Srinivas
Cc: r-help@r-project.org
Subject: Re: [R] RMySQL on Windows 2008 64 Bit -Help!
did you try the RODBC package as well.
Regards
Ajay
Websites-
http://decisionstats.com
http://dudeofdata.com
Linkedin- www.linkedin.com/in/ajayohri
On Sat, Nov 13, 2010 at 9:22 AM, Santosh Srinivas
<santosh.srini...@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
Sys.getenv('MYSQL_HOME')
MYSQL_HOME
"C:/Program Files/MySQL/MySQL Server 5.0"
install.packages('RMySQL',type='source')
trying URL
'http://cran.revolutionanalytics.com/src/contrib/RMySQL_0.7-5.tar.gz'
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
'C:/Revolution/Revo-4.0/RevoEnt64/R-2.11.1/library/RMySQL'
The downloaded packages are in
'C:\Users\Administrator\AppData\Local\Temp\2\RtmpvGgrzb\downloaded_packages'
Warning message:
In install.packages("RMySQL", type = "source") :
installation of package 'RMySQL' had non-zero exit status
sessionInfo()
R version 2.11.1 (2010-05-31)
x86_64-pc-mingw32
locale:
[1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United
States.1252 LC_MONETARY=English_United States.1252 LC_NUMERIC=C
[5] LC_TIME=English_United States.1252
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] Revobase_4.0.0 RevoScaleR_1.0-0 lattice_0.18-8
loaded via a namespace (and not attached):
[1] grid_2.11.1 tools_2.11.1
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
