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]]
______________________________________________
R-help@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.
