[R-sig-DB] connecting to remote database using RMySQL, from WinXP Pro

[Tomoaki NISHIYAMA]

Hi,

Did you exactly follow http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL
?
especially MYSQL_HOMEE environmental variable and
MySQL client library install path?

If you followed the instruction you would have shown
Sys.getenv('MYSQL_HOME')
instead of Sys.getenv("MYSQL_USER")
See, the difference of HOME and USER.

The message says the R couldn't find MySQL library and the
location will be directed by MYSQL_HOME.
-- 
Tomoaki NISHIYAMA

Advanced Science Research Center,
Kanazawa University,
13-1 Takara-machi,
Kanazawa, 920-0934, Japan


On 2010/11/06, at 4:54, Jan Theodore Galkowski wrote:

> (Sorry, cross-posted from R-Help to more appropriate venue.)
>
> On Fri, 05 Nov 2010 19:32 +0000, "Jan Theodore Galkowski"
> <bayesianlogic using acm.org> wrote:
>
> 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
> Error : .onLoad failed in loadNamespace() for 'RMySQL', details:
> call: utils::readRegistry("SOFTWARE\\MySQL AB", hive = "HLM",
> maxdepth = 2)
> error: Registry key 'SOFTWARE\MySQL AB' not found
> Error: package/namespace load failed for 'RMySQL'
>>
>
> I don't even get to do anything more.
>
>  - Jan
>
>
> On Fri, 05 Nov 2010 17:14 -0200, "Henrique Dallazuanna"
> <wwwhsd using gmail.com> wrote:
>
>   library(RMySQL)
>   conn <- dbConnect(MySQL(), user = 'user', password =
>   'password', host = '[1]your_host.com')
>   Look at [2]http://biostat.mc.vanderbilt.edu/RMySQL for more
>   information
>
> On Fri, Nov 5, 2010 at 5:04 PM, Jan Theodore Galkowski
> <[3]bayesianlogic using acm.org> wrote:
>
>   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 fails to load.
>   Thing is, I'm trying to access a MySQL database on a remote
>   machine for which I have authorized access. Anyone know how to
>   do
>   this, or suggest where I can find out?
>   Thanks.  I have successfully accessed remote databases using
>   RODBC.  Is that how I need to go?
>    - Jan
>
>
>
> [snip]
>
> References
>
> 1. http://your_host.com/
> 2. http://biostat.mc.vanderbilt.edu/RMySQL
> 3. mailto:bayesianlogic using acm.org
> --
>   Jan Theodore Galkowski  (o�)
>
>   607.239.1834 [mobile]
>   607.239.1834 [home]
>   617.444.4995 [work]
>
>  bayesianlogic using acm.org
>  http://www.linkedin.com/in/deepdevelopment
>
>
>  "Eppur si muove." --Galilei
>
>
>
> 	[[alternative HTML version deleted]]
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db