From spencer.graves at structuremonitoring.com  Fri Sep 17 17:50:06 2010
From: spencer.graves at structuremonitoring.com (Spencer Graves)
Date: Fri, 17 Sep 2010 08:50:06 -0700
Subject: [Rd] How to connect R to Mysql?
In-Reply-To: <AANLkTi=ca5M_jbzexYE8KXQ0nKCz1xbui4uXgoGBK1N3@mail.gmail.com>
References: <AANLkTi=ca5M_jbzexYE8KXQ0nKCz1xbui4uXgoGBK1N3@mail.gmail.com>
Message-ID: <4C938E2E.6020000@structuremonitoring.com>



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


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



[Rd] How to connect R to Mysql?
Spencer Graves