[Rd] trouble compiling RMySQL (and others) for 64 bit windows.

zoolium amosfolarin at gmail.com
Tue Feb 22 18:05:26 CET 2011

I recently found a solution to the RMySQL compiling problem. 

You however there is one additional requirement at present (with the MySQL
server version 5.5 & R2.12.1) follow the
http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL instructions at present as
the locations of the libmySQL.dll differs to what is expected in the

i.e. for the 64bit compiling. 
it expects the libmySQL.dll to be in "${MYSQL_HOME}"/bin/libmySQL.dll
so simply copy the dll over to the /bin dir and it will now compile.

for the 32bit compilling.
the libmySQL.lib is expected in "${MYSQL_HOME}"/lib/opt/libmysql.lib
again moving this should solve the problem.

Alternatively, if you don't want to or can't move these files. Then you can
edit the source code files:
 appropriately pointing to /lib/libmysql.dll /lib/libmysql.lib

View this message in context: http://r.789695.n4.nabble.com/trouble-compiling-RMySQL-and-others-for-64-bit-windows-tp2549336p3319623.html
Sent from the R devel mailing list archive at Nabble.com.

More information about the R-devel mailing list