Re: [R] connecting to remote database using RMySQL

2010-11-05 Thread Daniel Nordlund
> -Original Message- > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] > On Behalf Of Jan Theodore Galkowski > Sent: Friday, November 05, 2010 12:05 PM > To: R Project > Subject: [R] connecting to remote database using RMySQL > > Apolog

Re: [R] connecting to remote database using RMySQL

2010-11-05 Thread Jan Theodore Galkowski
Yes, what happens when I do that is: R version 2.11.1 (2010-05-31) Copyright (C) 2010 The R Foundation for Statistical Computing ISBN 3-900051-07-0 [snip] > Sys.getenv("MYSQL_USER") MYSQL_USER "mf1" > # As an example. Other env vars are defined. > library(RMySQL) Loading required package: DBI Erro

Re: [R] connecting to remote database using RMySQL

2010-11-05 Thread Henrique Dallazuanna
library(RMySQL) conn <- dbConnect(MySQL(), user = 'user', password = 'password', host = ' your_host.com') Look at http://biostat.mc.vanderbilt.edu/RMySQL for more information On Fri, Nov 5, 2010 at 5:04 PM, Jan Theodore Galkowski < bayesianlo...@acm.org> wrote: > Apologies if this is the wrong p

[R] connecting to remote database using RMySQL

2010-11-05 Thread Jan Theodore Galkowski
Apologies if this is the wrong place to ask. I'm not aware of a mail list devoted to database interfaces. Please direct me if so. I am trying to use TSMySQL. It loads RMySQL, and apparent the CRAN version has an .onLoad script which seeks out the local MySQL server. If that fails, the package f