Thank you very much for your comments. Finally I installed it~ :-) But I have one more general question.
Using the RMySQL package and DBI, Can I install the R object to the database? I mean, suppose I got the Objects from matest function or fitmaanova function. If I want to save the results to the database table, is it possible? Now I looked up the most functions that are related with database, but, I couldn't find it. is it possible? Thanks in advance. ---- Original message ---- >Date: Tue, 15 Mar 2005 07:16:07 +0000 (GMT) >From: Prof Brian Ripley <[EMAIL PROTECTED]> >Subject: Re: [R] Install the RMySQL >To: "Ko,Younhee" <[EMAIL PROTECTED]> >Cc: [email protected] > >On Mon, 14 Mar 2005, Ko,Younhee wrote: > >> Hi, I have some problem to install RMySQL package. >> Could you help me? > >Please tell us your OS, R version, etc. > >> I set up the path. > >You set a couple of variables, but no path. (These at most supplement the >include and library paths.) > >> [EMAIL PROTECTED] library]# export PKG_CPPFLAGS="-I/var/lib/mysql" >> [EMAIL PROTECTED] library]# export PKG_LIBS="-L/var/lib/mysql - >> lmysqlclient" > >Looks like your MySQL files are not where you claim they: I would not >expect them to be there (headers are not normally in a 'lib' directory), >but where they are depends on whether this is an installation from the >sources (not likely if it uses /var/lib), RPM etc. E.g. FC3 has > >checking for mysql_init in -lmysqlclient... yes > mysqlclient found in -L/usr/lib/mysql >checking for /usr/local/include/mysql/mysql.h... no >checking for /usr/include/mysql/mysql.h... yes > >Note to David James as maintainer: should not finding these be an error, >or at least give a very loud warning from configure? > > >> [EMAIL PROTECTED] library]# R CMD INSTALL /home/younko/RMySQL_0.5- >> 5.tar.gz >> >> >> I got this bunch of error message. >> >> >> >> Please help me. >> >> >> * Installing *source* package 'RMySQL' ... >> creating cache ./config.cache >> checking how to run the C preprocessor... cc -E >> checking for compress in -lz... yes >> checking for getopt_long in -lc... yes >> checking for mysql_init in -lmysqlclient... no >> checking for mysql.h... no >> updating cache ./config.cache >> creating ./config.status >> creating src/Makevars >> ** libs >> gcc -I/usr/local/lib/R/include -I/var/lib/mysql - >> I/usr/local/include -fPIC -g -O2 -c RS-DBI.c -o RS- DBI.o >> gcc -I/usr/local/lib/R/include -I/var/lib/mysql - >> I/usr/local/include -fPIC -g -O2 -c RS-MySQL.c -o RS- >> MySQL.o >> In file included from RS-MySQL.c:22: >> RS-MySQL.h:40:19: mysql.h: No such file or directory >> RS-MySQL.h:41:27: mysql_version.h: No such file or directory >> RS-MySQL.h:42:23: mysql_com.h: No such file or directory > >That's sufficient info. > >-- >Brian D. Ripley, [EMAIL PROTECTED] >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 ======================== Younhee Ko([EMAIL PROTECTED]) http://comedu.korea.ac.kr/~unygo contact : 217-417-4868 Graduate Student in Dept. of Computer Science University of Illinois at Urbana-Champaign ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
