R: How to install RMySQL in Windows 7 with MySQL 5.5

06Jun11

This post is based completely (except for the bold characters) in the thread in http://stackoverflow.com/questions/5223113/using-mysql-in-r-for-windows,
about how to install RMySQL in Windows 7 with MySQL 5.5
The answer is due to:
Yuriy Petrovskiy

“Found solution with help of ran2, who gave me link to common question. The basic process is described here, but there are several hints, So I will describe the whole solution (please change the R version and paths if needed):

1. Install latest RTools from here
2. install MySQL or header and library files of mysql
3. create or edit file C:\Program Files\R\R-2.12.1\etc\Renviron.site and add line like MYSQL_HOME=C:/mysql (path to your mysql files)
4. copy libmysql.lib from mysql/lib to mysql/lib/opt to meet dependencies.
5. copy libmysql.dll to C:\Program Files\R\R-2.13.0\bin\i386 or to windows/system32 directory.
6. run install.packages(‘RMySQL’,type=’source’) and wait while compilation will end.

Hope it helps.



No Responses Yet to “R: How to install RMySQL in Windows 7 with MySQL 5.5”

  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Follow

Get every new post delivered to your Inbox.

%d bloggers like this: