I have been trying to install RMySQL on Windows 7 following the procedure at: http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL I think I have properly installed RTools and created a proper Renviron.site file saying: MYSQL_HOME="C:/Program Files/MySQL/MySQL Server 5.5" When I try to install the packages from source, I get warnings that suggest I'm still not quite "with the program" yet. There are comments about POSIX paths that I don't quite grasp. Can anyone give me additional hints? There seems to be a libmysql.dll in the /lib subdirectory although the install seems to be looking in the /bin directory for a file of similar name. Is this something that has changed with recent versions of MySQL that should be fixed in the RMySQL package or is it something I can work around by hand or by properly setting some environmental variable? Thanks, ----- -- View this message in context: http://r.789695.n4.nabble.com/RMySQL-install-on-windows-tp4651660.html Sent from the R help mailing list archive at Nabble.com.
RMySQL install on windows
2 messages · rahul143, Gabor Grothendieck
On Sun, Dec 2, 2012 at 11:35 AM, rahul143 <rk204885 at gmail.com> wrote:
I have been trying to install RMySQL on Windows 7 following the procedure at: http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL I think I have properly installed RTools and created a proper Renviron.site file saying: MYSQL_HOME="C:/Program Files/MySQL/MySQL Server 5.5" When I try to install the packages from source, I get warnings that suggest I'm still not quite "with the program" yet. There are comments about POSIX paths that I don't quite grasp. Can anyone give me additional hints? There seems to be a libmysql.dll in the /lib subdirectory although the install seems to be looking in the /bin directory for a file of similar name. Is this something that has changed with recent versions of MySQL that should be fixed in the RMySQL package or is it something I can work around by hand or by properly setting some environmental variable?
There likely has been some change in the location of the dll's in various versions of MySQL. See: http://www.mail-archive.com/r-help at r-project.org/msg185838.html -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com