[R] Problem installing RMySQL package!

R. Michael Weylandt michael.weylandt at gmail.com
Wed Mar 14 13:59:33 CET 2012

In addition to Dr. Ellison's sound advice, as the link says: follow
the provided link, go to a CRAN mirror
(http://cran.r-project.org/mirrors.html), click "download for windows"
and Rtools will be available.


On Wed, Mar 14, 2012 at 1:14 AM, AGGARWAL, NEERAJ (NEERAJ)
<Neeraj.Aggarwal at alcatel-lucent.com> 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?
> Regards,
> Neeraj Aggarwal
>        [[alternative HTML version deleted]]
> ______________________________________________
> R-help at 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.

More information about the R-help mailing list