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]]
> -----Original Message----- > From: r-help-bounces at r-project.org > [mailto:r-help-bounces at r-project.org] On Behalf Of AGGARWAL, > NEERAJ (NEERAJ) > Sent: 14 March 2012 05:14 > To: r-help at r-project.org > Subject: [R] Problem installing RMySQL package! > > 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_packa > ges/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> Is RTools something different from RProject.Read 'R installation and administration' in your R Help system. That will tell you what R Tools is/are and where to get them. In relation to accessing a MySQL database, you could also consider installing RODBC (which installs from binary unsinf install.packages()), registering your MySQL database as an ODBC data source in Windows and then using RODBC's query facilities. That certainly works for ordinary SELECTS, INSERTS and UPDATES, and does not require RMySQL. S******************************************************************* This email and any attachments are confidential. Any use...{{dropped:8}}
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. Michael 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.
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