[Rd] How to connect R to Mysql?

Spencer Graves spencer.graves at structuremonitoring.com
Fri Sep 17 18:47:13 CEST 2010


  Hi, Thomas:


       You use RODBC to connect to MySQL?


       Thanks, Spencer


On 9/17/2010 9:26 AM, Thomas Etheber wrote:
> I also had problems connecting via RMysql on Windows several weeks ago.
> I decided to skip the package and now use RODBC, which runs stable out 
> of the box. Perhaps you should have a look at this package.
>
> Hth
> Thomas
>
> Am 17.09.2010 17:50, schrieb Spencer Graves:
>>
>>
>>       I've recently been through that with some success.  I don't 
>> remember all the details, but I first looked at "help(pac=RMySQL)".   
>> This told me that the maintainer was Jeffrey Horner.  Google told me 
>> he was at Vanderbilt.  Eventually I found 
>> "http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL", which told me 
>> that I needed to build the package myself so it matches your version 
>> of MySQL, operating system, etc.  I did that.
>>
>>
>>       Does the MySQL database already exist?  I created a MySQL 
>> database and tables using MySQL server 5.1.50-win32.  (Which version 
>> of MySQL do you have?)
>>
>>
>>       help('RMySQL-package') includes "A typical usage".  That helped 
>> me get started, except that I needed to write to that database, not 
>> just query it.  For this, I think I got something like the following 
>> to work:
>>
>>
>> d <- dbReadTable(con, "WL")
>> dbWriteTable(con, "WL2", a.data.frame)  ## table from a data.frame
>> dbWriteTable(con, "test2", "~/data/test2.csv") ## table from a file
>>
>>
>>       Hope this helps.
>>       Spencer
>>
>>
>> On 9/17/2010 7:55 AM, Arijeet Mukherjee wrote:
>>> I installed the RMySql package in R 2.11.1 64 bit
>>> Now how can I connect R with MySql?
>>> I am using a windows 7 64 bit version.
>>> Please help ASAP.
>>>
>>
>>
>
> ______________________________________________
> R-devel at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
>
>


-- 
Spencer Graves, PE, PhD
President and Chief Operating Officer
Structure Inspection and Monitoring, Inc.
751 Emerson Ct.
San José, CA 95126
ph:  408-655-4567



More information about the R-devel mailing list