[R] RMySQL Installation Error

[avinash barnwal]

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