[R-sig-DB] RMySQL error under Windows Server 2008 64-bit

[Prof Brian Ripley]

Are you running R on that server?

If not (the most likely answer), you need MySQL on the client.

If yes, I think you need 32-bit MySQL for RMySQL, even with a 64-bit 
server, since R for Windows is 32-bit.  But I've not seen a 64-bit Windows 
install of MySQL.

On Fri, 19 Dec 2008, Michael Styer wrote:

> Hello,
>
> I'm trying to use RMySQL under Windows Server 2008 64-bit and I encounter the 
> following errors. MySQL version 5.0.67 is installed and running.
>
> Initially when loading RMySQL I got this error:
>
>> library("RMySQL")
> Error in fun(...) : MySQL is not installed according to a Registry search
> In addition: Warning message:
> package 'RMySQL' was built under R version 2.8.1
> Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
> Error: package/namespace load failed for 'RMySQL'
>
> Then I tried setting the environment variable MYSQL_HOME="C:\\Program 
> Files\\MySQL\\MySQL Server 5.0\\", which is the installation directory for 
> the MySQL installation on this server. After that, when loading RMySQL I get 
> this error:
>
>> library("RMySQL")
> Loading required package: DBI
> Error : MYSQL_HOME was set but does not point to a directory
> In addition: Warning message:
> package 'RMySQL' was built under R version 2.8.1
> Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
> Error: package/namespace load failed for 'RMySQL'
>
> What else should I try to get RMySQL to load correctly?
>
> Thanks very much.
>
> Michael
>
> _______________________________________________
> 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
>

-- 
Brian D. Ripley,                  ripley using 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