[R] getting started with RMySQL

[Laurent Faisnel]

Hi all,
I'm trying to make the connection between R and MySQL. I set connection 
parameters such as dbname, user, host in file .my.cnf

 >library(DBI)
 >library(RMySQL)
 > drv <- dbDriver("MySQL")
 > con <- dbConnect(drv)

Until here evrything's ok.

But there are lots of commands I found in R docs which are "not found", 
such as getTable. Deprecated (I successfully used dbListTables) or do I 
simply miss a package ?
How should I use resultSets ? I am not able to close neither a 
connection nor a ResultSet. I tried with close(con).

Thanks for any help.

Laurent