[R] Install the RMySQL

[Ko,Younhee]

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 <ripley at stats.ox.ac.uk>  
>Subject: Re: [R] Install the RMySQL   
>To: "Ko,Younhee" <younko at uiuc.edu>
>Cc: R-help at stat.math.ethz.ch
>
>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.)
>
>> [root at ep2 library]# export PKG_CPPFLAGS="-I/var/lib/mysql"
>> [root at ep2 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?
>
>
>> [root at ep2 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,                  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
========================
Younhee Ko(younko at uiuc.edu)

http://comedu.korea.ac.kr/~unygo
contact : 217-417-4868
Graduate Student in Dept. of Computer Science
University of Illinois at Urbana-Champaign