Skip to content

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

1 message · Amos Folarin

Original
Amos Folarin
# 
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
package.

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:
Makevars.win
Makevars.win32
Makevars.win64
 appropriately pointing to /lib/libmysql.dll /lib/libmysql.lib