From amosfolarin at gmail.com  Tue Feb 22 18:05:26 2011
From: amosfolarin at gmail.com (zoolium)
Date: Tue, 22 Feb 2011 09:05:26 -0800 (PST)
Subject: [Rd] trouble compiling RMySQL (and others) for 64 bit windows.
In-Reply-To: <4CDEDD26.6050201@statistik.tu-dortmund.de>
References: <AANLkTinDSqVgdtt2qJ634_2QTOADQbbxiiXC-qoFrFj_@mail.gmail.com>
	<4CDEDD26.6050201@statistik.tu-dortmund.de>
Message-ID: <1298394326417-3319623.post@n4.nabble.com>


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











-- 
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.



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