[R] Problem installing RMySQL package!

Gabor Grothendieck ggrothendieck at gmail.com
Wed Mar 14 14:19:13 CET 2012

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?

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

More information about the R-help mailing list