[R] Install RMySQL with R 2.4.0

[Joe Byers]

Dan Rie wrote:
> 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.
>
What do you do if you are accessing the Mysql server remotely from the 
machine that R is install upon.  No MYsql libraries or other files are 
stored on either of my computers.

Thank you

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