I am facing issues while installing RMySQL package on windows(32 bit)
installation of R-Project.
I am getting the following warning messages.
Warning messages:
1: running command 'C:/PROGRA~1/R/R-213~1.2/bin/i386/R CMD INSTALL -l
"C:/Program Files/R/R-2.13.2/library"
D:\DOCUME~1\nagga002\LOCALS~1\Temp\RtmpLZndlE/downloaded_packages/RMySQL_0.9-3.tar.gz'
had status 1
2: In install.packages("RMySQL", type = "source") :
installation of package 'RMySQL' had non-zero exit status
It seems many people faced the issue and some got it resolved manipulating with
some jars.
I got one solution from -
http://stackoverflow.com/questions/4785933/adding-rmysql-package-to-r-fails/5236954#5236954
The basic process is described
here<http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL>, but there are several
hints, So I will describe the whole solution(please change the R version and
paths if needed):
1. Install latest RTools from
here<http://www.murdoch-sutherland.com/Rtools/>
2. install MySQL or header and library files of mysql
3. create or edit file C:\Program
Files\R\R-2.12.1\etc\Renviron.site and add line likeMYSQL_HOME=C:/mysql (path
to your mysql files)
4. copy libmysql.lib from mysql/lib to mysql/lib/opt to meet
dependencies.
5. copy libmysql.dll to C:\Program Files\R\R-2.12.1\bin or to
windows/system32 directory.
6. run install.packages('RMySQL',type='source') and wait while
compilation will end.
This worked for me on Windows 7 64 bit, so there should be no problems with 32
bit versions
II tried the above steps, but I am still facing problems.
Is RTools something different from RProject. I did not find anything by the
name RTools at the given link?
Regards,
Neeraj Aggarwal
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
