On Wed, Mar 14, 2012 at 1:14 AM, AGGARWAL, NEERAJ (NEERAJ) <[email protected]> wrote: > 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?
The above description is outdated if you are using the latest version of RMySQL. Install Rtools from http://cran.r-project.org/bin/windows/Rtools and then look at the Windows section of the "Installation Info" link at http://cran.r-project.org/package=RMySQL (which is the installation information that comes with the package itself). -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com ______________________________________________ [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.
