[R] RMySQL install

[Robert Schneider]

Hi everyone,

I am trying to install the RMySQL package under windows xp. I've got the MySQL installed on the computer (MySQL server 5.1). I went through the steps presented on the webpage http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL and googled around and still can't find the answer. With the command

readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)

I get the following info:

-------------------------------------------------------------------------------------------------------------
$`MySQL Connector/ODBC 5.1`
$`MySQL Connector/ODBC 5.1`$Version
[1] "5.1.6"

$`MySQL Server 5.1`
$`MySQL Server 5.1`$DataLocation
[1] "C:\\Documents and Settings\\All Users\\Application Data\\MySQL\\MySQL Server 5.1\\"

$`MySQL Server 5.1`$FoundExistingDataDir
[1] "0"

$`MySQL Server 5.1`$Location
[1] "C:\\Program Files\\MySQL\\MySQL Server 5.1\\"

$`MySQL Server 5.1`$Version
[1] "5.1.42"

$`MySQL Workbench 5.2 OSS`
$`MySQL Workbench 5.2 OSS`$Location
[1] "C:\\Program Files\\MySQL\\MySQL Workbench 5.2 OSS\\"

$`MySQL Workbench 5.2 OSS`$Version
[1] "5.2.14"
-------------------------------------------------------------------------------------------------------------

Everything seems to be ok. However, when loading the package, I get (sorry, it's in French):

-------------------------------------------------------------------------------------------------------------
Le chargement a nécessité le package : DBI
Error in if (utils::file_test("-d", MySQLhome)) break : 
  l'argument est de longueur nulle
De plus : Messages d'avis :
1: le package 'RMySQL' a été compilé avec la version R 2.10.1 
2: le package 'DBI' a été compilé avec la version R 2.10.1 
Error : .onLoad a échoué dans 'loadNamespace' pour 'RMySQL'
Erreur : le chargement du package / espace de noms a échoué pour 'RMySQL'
-------------------------------------------------------------------------------------------------------------

Do you need MySQL Server 5.0, or will it work with 5.1 also ?

Thanks for any help.

Rob