[R] Install RMySQL with R 2.4.0

[Dan Rie]

I had a very similar problem installing RMySQL with R 2.4.0 on  Windows XP.
I beleive that the cause may have been that the RMySQL build used a slightly 
older version of the MySQL compiled library functions than was installed on 
my machine (I updated both MySQL, DBI, and RMySQL to latest versions prior 
to attempting the install).  Since RMySQL links to the compiled MySQL 
library, slight differences could affect the linked references.  I do not 
know that this is the source of the problem, but it was one obvious point of 
fraility.

The solution, suggested by Prof. Brian Ripley on the r-sig-db list, was to 
rebuild the RMySQL library from source prior to doing the install.  After 
completing the recompilation of the RMySQL package, the install worked as it 
should.  I believe that the binaries for RMySQL may have been updated since 
I had those problems, so you might also want to make sure that you have the 
latest version of all the packages.


Date: Sat, 04 Nov 2006 23:53:11 -0600
From: "Joe W. Byers" <Joe-Byers at utulsa.edu>
Subject: Re: [R] Install RMySQL with R 2.4.0
To: r-help at stat.math.ethz.ch
Message-ID: <eiju5b$ruk$1 at sea.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Seth Falcon wrote:
> "Joe W. Byers" <Joe-Byers at utulsa.edu> writes:
>
>> I am having trouble as well with the new version of R 2.4.  I downloaded
>> the gz file from the cran website,  followed the instructions in the
>> README.win file and installed RMySQL.  I have mysql installed under
>> c:\mysql not the program files directory which is the only difference.
>>
>> I get the following error when I attempt to connect to the MySQL Db
>>  > ## open a connection to a MySQL database
>>  > con <- dbConnect(dbDriver("MySQL"),host='localhost',
>> + username='XXXX',dbname = 'StorageSims');
>> Error in function (classes, fdef, mtable)  :
>>          unable to find an inherited method for function "dbConnect",
>> for signature "MySQLDriver"
>>  >
>>
>> Any help will be appreciated.  I would like to note that there are no
>> problems with RMySQL on my linux system, only on XP's.
>
> Just to make sure:
>
> Before trying the code you posted, you did library("RMySQL"), right?
YES
>
> Also, what versions of DBI and RMySQL are you using?
RMySQL from http://cran.r-project.org/src/contrib/Descriptions/RMySQL.html
DBI Version 0.1-10 according to the NEWS file in ../R/library
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> 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.
>