[R] Fwd: RMySQL and Mac OS X

[Jan de Leeuw]

Begin forwarded message:

> From: Arno Ouwehand <arno at stat.ucla.edu>
> Date: Wed Jul 3, 2002  16:00:54 America/Los_Angeles
> To: fernando.pineda at jhu.edu
> Cc: deleeuw at stat.ucla.edu
> Subject: RMySQL and Mac OS X
>
> I got it working, initially I had the same problem (using R1.5.0 and Mysql-3.23.49 )
> Then I installed the  R 1.5.1 MetaPackage from http://cran.stat.ucla.edu/bin/macosx/ and
> MySQL 3.23.51 from www.entropy.ch and RMySQL using the following command:
>
> sudo R CMD INSTALL --configure-args='--with-mysql-
> lib=/usr/local/mysql/lib --with-mysql-inc=/usr/local/mysql/include' RMySQL_0.4-6.tar.gz
>
> Then in R:
>
> > library(RMySQL)
> > m <- MySQL()
> >describe (m)
> <MySQLManager:(1924)>
>   Driver name:  MySQL
>   Max  connections: 10
>   Conn. processed: 0
>   Default records per fetch: 500
>   Open connections: 0
> > c <- dbConnect(m, dbname = "r", user="xxx", password="xxx")
> >describe(m)
> <MySQLManager:(1924)>
>   Driver name:  MySQL
>   Max  connections: 10
>   Conn. processed: 1
>   Default records per fetch: 500
>   Open connections: 1
> > s <- dbExecStatement(c, "select * from user")
> > data <- fetch(s, n = -1)
> > print (data)
>
> etc.
>
> Sincerely,
>
> Arno Ouwehand
> UCLA Department of Statistics
>
> p.s. Jan, maybe you could submit this to the r-help mailinglist
>
>
===
Jan de Leeuw; Professor and Chair, UCLA Department of Statistics;
US mail: 9432 Boelter Hall, Box 951554, Los Angeles, CA 90095-1554
phone (310)-825-9550;  fax (310)-206-5658;  email: deleeuw at stat.ucla.edu
homepage: http://www.stat.ucla.edu/~deleeuw
========================================================
           No matter where you go, there you are. --- Buckaroo Banzai
                    http://www.stat.ucla.edu/~deleeuw/sounds/nomatter.au
========================================================

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._