Skip to content

R on Windows and RMySQL

3 messages · silv at access.unizh.ch, Duncan Murdoch

silv at access.unizh.ch
# 
I have successfully installed R (version 2.8.1) and RMySQL (version 0.7-4) 
on my PC (Windows). Now I have a problem running RMySQL on R. I constantly 
receive the following error-message:

Error in utils::readRegistry("SOFTWARE\\MySQL AB", hive = "HLM", maxdepth = 
2) :
   Registry-Schl?ssel 'S' nicht gefunden
Error : .onLoad in 'loadNamespace' f?r 'RMySQL' fehlgeschlagen
Fehler: Laden von Paket/Namensraum f?r 'RMySQL' fehlgeschlagen

Does anyone have a clue what I should do? I don`t have any experience in 
such issues. I have not installed MySQL on my PC. Could this be the solution 
to my problem? Is it true that RMySQL does work properly on R only if you 
first install MySQL?

Thanks for your answer...
Duncan Murdoch
#
On 4/17/2009 6:48 AM, silv at access.unizh.ch wrote:
That's what it looks like.  I'm not sure why it is reporting 'S' as a 
problem, but when I execute that line I see

 > readRegistry("SOFTWARE\\MySQL AB", hive = "HLM", maxdepth = 2)
$`MySQL Server 5.0`
$`MySQL Server 5.0`$Location
[1] "F:\\Program Files\\MySQL\\MySQL Server 5.0\\"

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


and when I change the key to a nonexistent one I see

 > readRegistry("SOFTWARE\\foobar", hive = "HLM", maxdepth = 2)
Error in readRegistry("SOFTWARE\\foobar", hive = "HLM", maxdepth = 2) :
   Registry key 'S' not found

I'll take a look at readRegistry and try to improve the error message.

Duncan Murdoch
Duncan Murdoch
#
On 4/17/2009 12:26 PM, Duncan Murdoch wrote:
On 4/17/2009 12:26 PM, Duncan Murdoch wrote:
The problem with the error message was simply a typo in the format 
string.  Easy to fix.

Your problem is the lack of MySQL on your system.  Also easy to fix?

Duncan Murdoch