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.
