[R] How To compile RMySQL on Windows?

Witold Eryk Wolski wolski at molgen.mpg.de
Mon Oct 23 17:46:04 CEST 2000


Thanks for the answers that I received.

I had downloaded the last distribution of RMySQL from
Its the first package that I am trying to compile under Windows.

>From the Compiler I am getting the following error message.
In file included from RMySQL.c:1:
RMySQL.h:24: mysql.h: No such file or directory
RMySQL.h:25: mysql_com.h: No such file or directory
make[2]: *** [RMySQL.o] Error 1
make[1]: *** [src/RMySQL.dll] Error 2
make: *** [pkg-RMySQL] Error 2

Have somebody an expample how the syntax is for passing the path of
include files? Is there a source for further information how to do it?

"If a package needs to specify additional directories for search-
ing header les (`-I' options) or additional libraries for linking (`-l'
and `-L' options), it
should do this by setting the variables PKG_CPPFLAGS and PKG_LIBS in

But no examples. :-(

RMySQL/src/Makevars. doesnt exists.
RMySQL/src/Makevars.in contains:

I added the path /prog/mysql/mysql/include \  to RMySQL/configure.in. But
it doesnt work.

After adding  -Id:/prog/mysql/mysql/include, to some lines in the Makefile
and MkRules Files in   the RHOME/src/gnuwin32 directory i got some
progress. But it appears to me that it is not the intended solution to
reedit each time the Makefile in src/gnuwin32 if a new Package have to be

Does anybody hava a compiled version of R.1.1.1 on Digital UNIX V4.0D or an
compiled verion of RMySQL for windows NT?


Eryk Witold Wolski
Max Plank Institut fuer Molekulare Genetik
Ihnestrasse 73 14195 Berlin

r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch

More information about the R-help mailing list