RE: [R] Basic questions about RMySQL

From: De la Vega Góngora Jorge <jvega_at_banxico.org.mx>
Date: Sat 19 Mar 2005 - 06:15:01 EST


Thanks for your help. having MySQL server locally (or in some other place) should solve the configuration problem.

By the way, I should have written forgive, no forget. Forgive me.

Jorge de la Vega  

-----Mensaje original-----
De: bogdan romocea [mailto:br44114@yahoo.com] Enviado el: Viernes, 18 de Marzo de 2005 01:11 PM Para: Uwe Ligges; De la Vega Góngora Jorge CC: r-help@stat.math.ethz.ch
Asunto: Re: [R] Basic questions about RMySQL

I certainly can't; I initially misunderstood the question.

If connecting to MySQL is the problem, then you need to know the user ID, the domain and the password. Ask your DB administrator for help.

Here's an example that works for me (local MySQL installation): require(DBI)
require(RMySQL)
MySQL(max.con = 16, fetch.default.rec = 5000, force.reload = F) drv <- dbDriver("MySQL") con <- dbConnect(drv,username="userid",password="pswd",dbname="db") dbListTables(con)


Do you Yahoo!?
Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/

R-help@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 Received on Sat Mar 19 06:18:21 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:30:51 EST