[R] Registry problem when loading RMySQL

[Prof Brian Ripley]

On Wed, 10 Dec 2008, Gerald van der Grijn wrote:

> Hi all,
>
> I am exploring the possibility of using R in my meteorological
> verification project. I have installed R on my Windows (XP) desktop
> machine and have also installed the RMySQL and verification packages.
> However, I run into problems when I try to load RMySQL. I get the
> following error:
>
> Error in fun(...) : MySQL is not installed according to a Registry
> search
>
> Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
>
> Error: package/namespace load failed for 'RMySQL'
>
> It seems that RMySQL should be installed on the same machine where the
> database resides. However, my MySQL database is on a separate server.
> Does anyone know how this error can be avoided?

You must have the MySQL client libraries on the machine running RMySQL.
The server can be on a different machine, but the client libraries are 
needed to talk to it.

R-sig-DB would have been a more appopriate list on which to ask this (with 
a more appropriate subject line).

> Thx,
>
> Gerald van der Grijn
>
>
>
>
>
> -- 
>
> This e-mail is from Meteo Consult B.V., a MeteoGroup company. For more information, see http://www.weer.nl/gebruiksvoorwaarden.
>
> This e-mail may contain confidential information. Only t...{{dropped:12}}
>
> ______________________________________________
> R-help at 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.
>

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595