Trying to install RMySQL on 64-bit Windows 7.
Using R-2.14.2 with Rtools214 and MySQL Server 5.5.
Read the few steps to install the original version of RMySQL.
Troubleshooting: - Copied libmysql.dll to R-2.14.2 / bin AND R-2.14.2 / bin / i386. - Copied libmysql.dll and libmysql.lib in MySQL Server 5.5 \ lib \ opt. - Introduced MYSQL_HOME = C: \ Program Files \ MySQL \ MySQL Server 5.5 in Renviron.site, saved in R \ R-2.14.2 \ etc.
My examples of common problems:
Sys.getenv ('MySQL_HOME') [1] "C: \ Program Files \ MySQL \ MySQL Server 5.5 \"
install.packages ('RMySQL', type = 'source') Installing package (s) ...... RS-DBI.c: 1: 0: sorry, not implemented: 64-bit mode, not compiled into make: [RS-DBI.o] Error 1 * ERROR: compilation failed for the RMySQL package ...
I assume that my problem is the message "64-bit mode ...", but I'm not sure.
Thoughts?
source
share