R help - May 2013 - connect to local mySQL database

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!

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]]