Hi Martin,
Can you clarify: are you trying to connect to a mySQL database, or to a
sqlite database? They're not at all the same thing, and I can't tell from
your question which you're after.
You need either RMySQL, or if you actually want an sqlite database, RSQLite
or sqldf.
Sarah
On Thursday, May 16, 2013, Martin Batholdy wrote:
> Hi,
>
> I would like to access a local mysql database.
>
> In python using the sqlite3 library it is quite straightforward. I just
> have to pass the path to the sqlite-file;
> sqlite3.connect('.../xy.sqlite')
>
> Is there something similar in R (or specifically in the RMySQL package)?
>
>
> It seems like I have to use the MySQL function in the RMySQL package in
> order to ...
> "initializes a MySQL client. It returns an driver object that allows you
> to connect to one or several MySQL servers."
>
>
> But is that also possible with a local mySQL database?
> Can't I just provide the information where to find the sqlite file and
> then open it?
>
>
> sorry if this are stupid questions,
> I am not very familiar with databases and just have to access a database
> on a shared network drive, which worked fine in python but seems to be not
> so straightforward in R.
>
>
> I am grateful for any suggestions!
>
>
>
--
Sarah Goslee
http://www.stringpage.com
http://www.sarahgoslee.com
http://www.functionaldiversity.org
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
