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]]

