On 10/10/2012 12:58 PM, Greg Snow wrote:
I finally was able to compile/load it under windows 7. I had similar
problems to what you show below.
I set the MYSQL_HOME environmental variable through windows (start
button > control panel > System and Security > system > Advanced
System Settings > Environmental variables). I had to set it to the
version of the path without spaces, in my case it was:
c:\PROGRA~1\MySQL\MYSQLS~1.5
Then I opened a command prompt window, changed to the directory where
I had downloaded the tar.gz file from cran and entered the command:
"c:\Program Files\R\R-2.15.1\bin\x64\R" CMD INSTALL RMySQL_0.9-3.tar.gz
and everything worked (it did not work if I used i386 or just the
regular bin folder, possibly due to the version of MySQL I
downloaded).
Then I started a new instance of R and did library(MySQL) and
everything loaded and I was able to connect to a local MySQL database.
Hope this helps you as well.
Thanks, Greg. I got a couple of warnings during the build, but I can
at least load the library. Now, I'll to to learn to use it<G>
I had downloaded the 64-bit MySQL engine. The seemingly successful
install was on R (64-bit).
I guess not unexpectedly I get the from R (i386)
> library(RMySQL)
Error: package ‘RMySQL’ is not installed for 'arch=i386'
Appreciate the guidance.
Rob
______________________________________________
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.