Using MySQL in R for Windows
mysql, r, windows
Solution
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):
- Install latest RTools from here
- install MySQL or header and library files of mysql
- 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)
- copy libmysql.lib from mysql/lib to mysql/lib/opt to meet dependencies.
- copy libmysql.dll to `C:\Program Files\R\R-2.12.1\bin` or to `windows/system32` directory.
- run `install.packages('RMySQL',type='source')` and wait while compilation will end.
Thanks to all who tried to answer.
Problem
How to use MySQL in R (statistic language) for Windows (7)? There is no problems then using linux: ``` install.packages('RMySQL') library(RMySQL) ... ``` But I found no such package for Windows on CRAN. There is only note about this fact. I found package for version 2.10, but it is not usable in 2.12.1. Also tried ``` install.packages("RMySQL", type="source") ``` but got an error : ``` * installing *source* package 'RMySQL' ... ERROR: configuration failed for package 'RMySQL' * removing 'C:/.../R/win-library/2.12/RMySQL' ``` Is there any way to connect to MySQL database from R in windows?