RMySQL on Windows 2008 64 Bit -Help!
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: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. 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.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
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 at 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 at 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.