Friday, September 30, 2011

RMySQL binary for Windows 7

I and my co-worker just had a heck of a time installing RMySQL on Windows 7.  Finally worked it out.  He & I did the same steps (we think) as each other, but mine succeeded & his failed.  So I built a binary for him, and figured I might as well post it here too.

  [ binary package ]

I used MySQL 5.5, with R 2.13.1.  I think you still have to install MySQL separately in order for this package to work.


At 11:00 PM, Blogger efg said...

What might have caused this?

Error: package ‘RMySQL’ is not installed for 'arch=i386'

On 64-bit Windows 7

At 11:49 AM, Blogger Nick Lee said...


I have been spending a heck of time for this. For some reason, I did everything the instruction says, nothing worked. Kazoom! I was excited finding your binary momentarily believing this could save my time. So I got the binary installed. However, I get the same error as efg questioned,

Error: package ‘RMySQL’ is not installed for 'arch=i386'

On 32-bit Windows 7. What causes this?

Do you have any guess?

At 4:02 PM, Blogger Tyler said...

Amazing, thanks so much! Just a note, I had to put

MYSQL_HOME = C:/Program Files/MySQL/MySQL Server 5.5

in in the

C:\Program Files\R\R-2.14.2\etc

directory to have it work. The other notation from the vanderbilt site didn't seem to work.

At 3:29 PM, Blogger Alton said...

Thanks this worked perfect!!!!! I too had a heck of a time.

At 9:58 PM, Blogger Franck Dernoncourt said...

Thanks, it was compiled with MySQL 5.5.15 but it seems to work great with MySQL 5.6.12 as well!

At 4:41 AM, Blogger Manisha said...

Thanks a lot!! I already have spent so much time into it. I regret I saw your post so late. Thanks Again..Manisha

At 4:39 PM, Blogger el pavo irreal said...

I'm sorry if this is an ignorant question, but how do we install the binary package? Thank you


Post a Comment

<< Home