[R] RMySQL on Windows 2008 64 Bit -Help!

Santosh Srinivas santosh.srinivas at gmail.com
Sat Nov 13 04:52:18 CET 2010

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')
"C:/Program Files/MySQL/MySQL Server 5.0" 

>  install.packages('RMySQL',type='source') 
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
> sessionInfo()
R version 2.11.1 (2010-05-31) 

[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

More information about the R-help mailing list