Re: [R] connecting [logging] RMySQL to an external server - SOLVED

2007-12-19 Thread Dirk Eddelbuettel
On Wed, Dec 19, 2007 at 07:51:47PM +0200, Adrian Dusa wrote: > Hi James, > > On Wednesday 19 December 2007, David James wrote: > > Hi, > > > > I'm sorry I'm also coming late to this discussion, but like Dirk, I > > fail to understand what's wrong with using dbConnect() the way > > the documentati

Re: [R] connecting [logging] RMySQL to an external server - SOLVED

2007-12-19 Thread Adrian Dusa
Hi James, On Wednesday 19 December 2007, David James wrote: > Hi, > > I'm sorry I'm also coming late to this discussion, but like Dirk, I > fail to understand what's wrong with using dbConnect() the way > the documentation, (see ?MySQL) suggests. > > RMySQL was developed in a fully distributed cl

Re: [R] connecting [logging] RMySQL to an external server - SOLVED

2007-12-19 Thread Adrian Dusa
On Wednesday 19 December 2007, Dirk Eddelbuettel wrote: > [...] > > Err, I am late to this but > > dbConnect(drv, user="mysqluser", password="mysqlpassword", > dbname="anydatabase", host="xxx.xxx.xxx") > > works fine for me (eg on Ubuntu with a remote MySQL on some other > box). What's the proble

Re: [R] connecting [logging] RMySQL to an external server - SOLVED

2007-12-19 Thread David James
Hi, I'm sorry I'm also coming late to this discussion, but like Dirk, I fail to understand what's wrong with using dbConnect() the way the documentation, (see ?MySQL) suggests. RMySQL was developed in a fully distributed client/server environment, and it uses the MySQL-provided client API. The

Re: [R] connecting [logging] RMySQL to an external server - SOLVED

2007-12-19 Thread Dirk Eddelbuettel
On Wed, Dec 19, 2007 at 04:34:26PM +0200, Adrian Dusa wrote: > On Saturday 15 December 2007, Gabor Grothendieck wrote: > > Use ssh forwarding to forward local port 3307 to remote port 3306 > > specifying the remote account and password. Then if you use local port > > 3306 you can access your local

Re: [R] connecting [logging] RMySQL to an external server - SOLVED

2007-12-19 Thread Adrian Dusa
On Saturday 15 December 2007, Gabor Grothendieck wrote: > Use ssh forwarding to forward local port 3307 to remote port 3306 > specifying the remote account and password. Then if you use local port > 3306 you can access your local version of MySQL and if you > use port 3307 you can access the remot