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
