I am installing RMySQL_0.9-3.tar.gz pkg on windows-7 64 bit machine as:---
C:\Users\trendwise> R CMD INSTALL
--configure-args='--with-mysql-inc="C:\\Program Files\\MySQL\\MySQL
Server
5.5\\include"'
"C:\\Users\\trendwise\\Downloads\\RMySQL_0.9-3.tar.gz"
* installing to library
'C:/Users/trendwise/Documents/R/win-library/2.14'
* installing *source* package 'RMySQL' ...
** package 'RMySQL' successfully unpacked and MD5 sums checked
checking for $MYSQL_HOME... C:\Program Files\MySQL\MySQL Server 5.5\.;
cygwin warning:
MS-DOS style path detected: C:\Program
Preferred POSIX equivalent is: /cygdrive/c/Program
CYGWIN environment variable option "nodosfilewarning" turns off this
warning.
Consult the user's guide for more details about POSIX paths:
http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
test: Files\MySQL\MySQL: unknown operand
** libs
Warning: this package has a non-empty 'configure.win' file,
so building only the main architecture
cygwin warning:
MS-DOS style path detected: C:/PROGRA~1/R/R-214~1.2/etc/x64/Makeconf
Preferred POSIX equivalent is:
/cygdrive/c/PROGRA~1/R/R-214~1.2/etc/x64/Makeconf
CYGWIN environment variable option "nodosfilewarning" turns off this
warning.
Consult the user's guide for more details about POSIX paths:
http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
gcc -m64 -I"C:/PROGRA~1/R/R-214~1.2/include" -I"C:\Program
Files\MySQL\MySQL
Server 5.5\.;"/include
-I"d:/RCompile/CRANpkg/extralibs64/local/include"
-O2 -Wall -std=gnu99 -mtune=core2 -c RS-DBI.c -o RS-DBI.o
RS-DBI.c: In function 'RS_na_set':
RS-DBI.c:1219:11: warning: variable 'c' set but not used
[-Wunused-but-set-variable]
gcc -m64 -I"C:/PROGRA~1/R/R-214~1.2/include" -I"C:\Program
Files\MySQL\MySQL
Server 5.5\.;"/include -I"d:/RCompile/CRANpkg/extr
alibs64/local/include" -O2 -Wall -std=gnu99 -mtune=core2 -c RS-MySQL.c
-o RS-MySQL.o
In file included from RS-MySQL.c:22:0:
RS-MySQL.h:32:19: fatal error: mysql.h: No such file or directory
compilation terminated.
make: *** [RS-MySQL.o] Error 1
ERROR: compilation failed for package 'RMySQL'
* removing 'C:/Users/trendwise/Documents/R/win-library/2.14/RMySQL'
======================================================================================================its
giving this error,
RS-MySQL.h:32:19: fatal error: mysql.h: No such file or directory
i want to include mysql.h path in either RCMD INSTALL or
install.packages() command
-----
Sagar Nikam
B.Pharm, M.Sc(Bioinformatics)
Software Engineer (Data Research Analyst )
Trendwise Analytics,Bangalore
India
--
View this message in context:
http://r.789695.n4.nabble.com/how-to-include-configure-args-in-R-CMD-INSTALL-tp4646220.html
Sent from the R help mailing list archive at Nabble.com.
Prof Brian Ripley
2012-Oct-15 15:09 UTC
[R] how to include --configure-args= in R CMD INSTALL
--configure-args are for Unix: you are on Windows. On 15/10/2012 11:47, sagarnikam123 wrote:> I am installing RMySQL_0.9-3.tar.gz pkg on windows-7 64 bit machine as:--- > > C:\Users\trendwise> R CMD INSTALL > --configure-args='--with-mysql-inc="C:\\Program Files\\MySQL\\MySQL Server > 5.5\\include"' "C:\\Users\\trendwise\\Downloads\\RMySQL_0.9-3.tar.gz" > > * installing to library 'C:/Users/trendwise/Documents/R/win-library/2.14' > * installing *source* package 'RMySQL' ... > ** package 'RMySQL' successfully unpacked and MD5 sums checked > checking for $MYSQL_HOME... C:\Program Files\MySQL\MySQL Server 5.5\.; > cygwin warning: > MS-DOS style path detected: C:\Program > Preferred POSIX equivalent is: /cygdrive/c/Program > CYGWIN environment variable option "nodosfilewarning" turns off this > warning. > Consult the user's guide for more details about POSIX paths: > http://cygwin.com/cygwin-ug-net/using.html#using-pathnames > test: Files\MySQL\MySQL: unknown operand > ** libs > Warning: this package has a non-empty 'configure.win' file, > so building only the main architecture > > cygwin warning: > MS-DOS style path detected: C:/PROGRA~1/R/R-214~1.2/etc/x64/Makeconf > Preferred POSIX equivalent is: > /cygdrive/c/PROGRA~1/R/R-214~1.2/etc/x64/Makeconf > CYGWIN environment variable option "nodosfilewarning" turns off this > warning. > Consult the user's guide for more details about POSIX paths: > http://cygwin.com/cygwin-ug-net/using.html#using-pathnames > gcc -m64 -I"C:/PROGRA~1/R/R-214~1.2/include" -I"C:\Program Files\MySQL\MySQL > Server 5.5\.;"/include -I"d:/RCompile/CRANpkg/extralibs64/local/include" > -O2 -Wall -std=gnu99 -mtune=core2 -c RS-DBI.c -o RS-DBI.o > RS-DBI.c: In function 'RS_na_set': > RS-DBI.c:1219:11: warning: variable 'c' set but not used > [-Wunused-but-set-variable] > gcc -m64 -I"C:/PROGRA~1/R/R-214~1.2/include" -I"C:\Program Files\MySQL\MySQL > Server 5.5\.;"/include -I"d:/RCompile/CRANpkg/extr > alibs64/local/include" -O2 -Wall -std=gnu99 -mtune=core2 -c RS-MySQL.c > -o RS-MySQL.o > In file included from RS-MySQL.c:22:0: > RS-MySQL.h:32:19: fatal error: mysql.h: No such file or directory > compilation terminated. > make: *** [RS-MySQL.o] Error 1 > ERROR: compilation failed for package 'RMySQL' > * removing 'C:/Users/trendwise/Documents/R/win-library/2.14/RMySQL' > ======================================================================================================> its giving this error, > RS-MySQL.h:32:19: fatal error: mysql.h: No such file or directory > i want to include mysql.h path in either RCMD INSTALL or > install.packages() command > > > > > > > > ----- > Sagar Nikam > B.Pharm, M.Sc(Bioinformatics) > Software Engineer (Data Research Analyst ) > Trendwise Analytics,Bangalore > India > -- > View this message in context: http://r.789695.n4.nabble.com/how-to-include-configure-args-in-R-CMD-INSTALL-tp4646220.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >-- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595