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