[R] RMySQL Installation Error

[avinash barnwal]

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