Dear laurent,> This is what I did to make the connection : > > drv <- dbDriver("MySQL") > > con <- dbConnect(drv)Here's the error. You should give the database name. drv <-dbConnect(drv, dbname="dfghdfgsdfgsdfgsdfgsdfgsdfgsdf") ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^> Then I should be able to send requests. But when I try this : > > dbListTables(con) > character(0)Of course. Tables are stored in the database. You didn't provide its name. Function dbListTables doesn't know which tables should it list. -- Best regards Wladimir Eremeev mailto:wl at eimb.ru =========================================================================Research Scientist Leninsky Prospect 33, Space Monitoring & Ecoinformation Systems Sector, Moscow, Russia, 119071, Institute of Ecology, Phone: (095) 135-9972; Russian Academy of Sciences Fax: (095) 954-5534
Wladimir Eremeev wrote:>Dear laurent, > > > >>This is what I did to make the connection : >> > drv <- dbDriver("MySQL") >> > con <- dbConnect(drv) >> >> > >Here's the error. >You should give the database name. >It is indicated in the config file my.cnf , no problem. In fact the database I tried to work on had a little problem yesterday, all tables disappeared a few hours long. Hence it was difficult to get any result. Thank you anyway. Parameters such as dbname, user, passwd, host, port can be given either in the config file my.cnf or at the time you define the connection in R (the solution you advised me).>drv <-dbConnect(drv, dbname="dfghdfgsdfgsdfgsdfgsdfgsdfgsdf") > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > >>Then I should be able to send requests. But when I try this : >> > dbListTables(con) >>character(0) >> >> > >Of course. >Tables are stored in the database. You didn't provide its name. >Function dbListTables doesn't know which tables should it list. > > >