Skip to content

RMySQL

2 messages · Vladimir Eremeev, Laurent Faisnel

#
Dear laurent,
Here's the error.
You should give the database name.
drv <-dbConnect(drv, dbname="dfghdfgsdfgsdfgsdfgsdfgsdfgsdf")
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Of course.
Tables are stored in the database. You didn't provide its name.
Function dbListTables doesn't know which tables should it list.
#
Wladimir Eremeev wrote:

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