[R] RMySQL Installation Error

[Prof Brian Ripley]

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