[R-sig-DB] Error connecting R to mysql

[Ian Coe]

Hi,
  I removed MySQL Tools and now I get the following error. 
 
Error in if (utils::file_test("-d", MySQLhome)) break : 
  argument is of length zero
Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
Error: package/namespace load failed for 'RMySQL'


I ran the registry search recommended on
http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL  Does anyone see the
problem here?

readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)
$`MySQL Connector/ODBC 5.1`
$`MySQL Connector/ODBC 5.1`$Version
[1] "5.1.5"


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

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

$`MySQL Server 5.0`$Version
[1] "5.0.81"


$`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] "1"

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

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