Keep in mind this page (http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL)
Install MySQL Community Server from (http://dev.mysql.com/downloads/mysql/)
Then (from StackOverflow)
- Go to
System->Advanced->Enviroment Variables
, pressNew
and Enter Variable name asMYSQL_HOME
and Variable values asC:/PROGRA~1/MYSQL/MYSQLS~1.6
, and notice that it is/
not\
. This is a bit different from the StackOverflow answer - the trick is to use the Windows shortname. Open a command window, go to your MySQL directory, and typedir /x
to get the correct particular ending. From R, confirm by typingSys.getenv("MYSQL_HOME")
.