Hi List,
I am trying to install RMySQL on Windows 7(64 Bit) with R Version 2.15.1 on
RStudio. I have also followed the steps mentioned on the different web
sources and finally drilled down to following steps:
1. *Installed MySQL to "C:\Program Files (x86)\MySQL\MySQL Server 5.6?*
2. * Added "MYSQL_HOME" with a value of "C:/Program Files
(x86)/MySQL/MySQL Server 5.6/"*
3. *Created the directory "opt" within "C:\Program Files
(x86)\MySQL\MySQL Server 5.6\lib" and copy-paste "C:\Program Files
(x86)\MySQL\MySQL Server 5.6\lib\libmysql.lib" to "C:\Program Files
(x86)\MySQL\MySQL Server 5.6\lib\opt\" and*
4. *Copy-paste "C:\Program Files\MySQL\MySQL Server
5.5\lib\libmysql.dll" to "C:\Program
Files\R\R-2.15.1\bin\i386\".*
*B But i am getting following error while executing
install.packages('RMySQL',type='source') command in RStudio.*
** preparing package for lazy loading
Error in setClass("MySQLDriver", contains = "DBIDriver",
slots = list(Id "integer")) :
unused argument(s) (slots = list(Id = "integer"))
Error : unable to load R code in package 'RMySQL'
ERROR: lazy loading failed for package 'RMySQL'
* removing 'C:/Users/barney/Documents/R/win-library/2.15/RMySQL'
Warning in install.packages :
running command 'C:/PROGRA~1/R/R-215~1.1/bin/x64/R CMD INSTALL -l
"C:/Users/barney/Documents/R/win-library/2.15"
C:\Users\barney\AppData\Local\Temp\RtmpgJXVPT/downloaded_packages/RMySQL_0.10.1.tar.gz'
had status 1
Warning in install.packages :
installation of package ?RMySQL? had non-zero exit status.
Request your help in solving the problem.
[[alternative HTML version deleted]]
On 22/02/2015 17:07, avinash barnwal wrote:> Hi List, > > I am trying to install RMySQL on Windows 7(64 Bit) with R Version 2.15.1 on > RStudio. I have also followed the steps mentioned on the different web > sources and finally drilled down to following steps:Hmm, those are not the correct instructions for the version of RMySQL you used. Undo them and follow the current instructions ....> > 1. *Installed MySQL to "C:\Program Files (x86)\MySQL\MySQL Server 5.6?* > 2. * Added "MYSQL_HOME" with a value of "C:/Program Files > (x86)/MySQL/MySQL Server 5.6/"* > 3. *Created the directory "opt" within "C:\Program Files > (x86)\MySQL\MySQL Server 5.6\lib" and copy-paste "C:\Program Files > (x86)\MySQL\MySQL Server 5.6\lib\libmysql.lib" to "C:\Program Files > (x86)\MySQL\MySQL Server 5.6\lib\opt\" and* > 4. *Copy-paste "C:\Program Files\MySQL\MySQL Server > 5.5\lib\libmysql.dll" to "C:\Program Files\R\R-2.15.1\bin\i386\".* > > *B But i am getting following error while executing > install.packages('RMySQL',type='source') command in RStudio.* > ** preparing package for lazy loading > > Error in setClass("MySQLDriver", contains = "DBIDriver", slots = list(Id > "integer")) : > > unused argument(s) (slots = list(Id = "integer")) > > Error : unable to load R code in package 'RMySQL' > > ERROR: lazy loading failed for package 'RMySQL' > > * removing 'C:/Users/barney/Documents/R/win-library/2.15/RMySQL' > > Warning in install.packages : > > running command 'C:/PROGRA~1/R/R-215~1.1/bin/x64/R CMD INSTALL -l > "C:/Users/barney/Documents/R/win-library/2.15" > C:\Users\barney\AppData\Local\Temp\RtmpgJXVPT/downloaded_packages/RMySQL_0.10.1.tar.gz' > had status 1 > > Warning in install.packages : > > installation of package ?RMySQL? had non-zero exit status. > > > Request your help in solving the problem.Follow the posting guide. Your R is very old, and you were asked to update before posting. Most likely that version of RMySQL requires a current version of R.> > [[alternative HTML version deleted]]Do not do that, as the posting guide required of you.> > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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. >-- Brian D. Ripley, ripley at stats.ox.ac.uk Emeritus Professor of Applied Statistics, University of Oxford 1 South Parks Road, Oxford OX1 3TG, UK
Dear Prof Brian, Thank you for telling the solution and from next time i will follow the posting guide. On Sun, Feb 22, 2015 at 11:51 PM, Prof Brian Ripley <ripley at stats.ox.ac.uk> wrote:> On 22/02/2015 17:07, avinash barnwal wrote: > >> Hi List, >> >> I am trying to install RMySQL on Windows 7(64 Bit) with R Version 2.15.1 >> on >> RStudio. I have also followed the steps mentioned on the different web >> sources and finally drilled down to following steps: >> > > Hmm, those are not the correct instructions for the version of RMySQL you > used. Undo them and follow the current instructions .... > > >> 1. *Installed MySQL to "C:\Program Files (x86)\MySQL\MySQL Server >> 5.6?* >> 2. * Added "MYSQL_HOME" with a value of "C:/Program Files >> (x86)/MySQL/MySQL Server 5.6/"* >> 3. *Created the directory "opt" within "C:\Program Files >> (x86)\MySQL\MySQL Server 5.6\lib" and copy-paste "C:\Program Files >> (x86)\MySQL\MySQL Server 5.6\lib\libmysql.lib" to "C:\Program Files >> (x86)\MySQL\MySQL Server 5.6\lib\opt\" and* >> 4. *Copy-paste "C:\Program Files\MySQL\MySQL Server >> 5.5\lib\libmysql.dll" to "C:\Program Files\R\R-2.15.1\bin\i386\".* >> >> *B But i am getting following error while executing >> install.packages('RMySQL',type='source') command in RStudio.* >> ** preparing package for lazy loading >> >> Error in setClass("MySQLDriver", contains = "DBIDriver", slots = list(Id >> "integer")) : >> >> unused argument(s) (slots = list(Id = "integer")) >> >> Error : unable to load R code in package 'RMySQL' >> >> ERROR: lazy loading failed for package 'RMySQL' >> >> * removing 'C:/Users/barney/Documents/R/win-library/2.15/RMySQL' >> >> Warning in install.packages : >> >> running command 'C:/PROGRA~1/R/R-215~1.1/bin/x64/R CMD INSTALL -l >> "C:/Users/barney/Documents/R/win-library/2.15" >> C:\Users\barney\AppData\Local\Temp\RtmpgJXVPT/downloaded_ >> packages/RMySQL_0.10.1.tar.gz' >> had status 1 >> >> Warning in install.packages : >> >> installation of package ?RMySQL? had non-zero exit status. >> >> >> Request your help in solving the problem. >> > > > Follow the posting guide. Your R is very old, and you were asked to > update before posting. Most likely that version of RMySQL requires a > current version of R. > > >> [[alternative HTML version deleted]] >> > > Do not do that, as the posting guide required of you. > >> >> ______________________________________________ >> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see >> 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. >> >> > > -- > Brian D. Ripley, ripley at stats.ox.ac.uk > Emeritus Professor of Applied Statistics, University of Oxford > 1 South Parks Road, Oxford OX1 3TG, UK >-- Avinash Barnwal, M.Sc. Statistics and Informatics Department of Mathematics IIT Kharagpur [[alternative HTML version deleted]]