Re: [R] Install the RMySQL

From: Ko,Younhee <younko_at_uiuc.edu>
Date: Wed 16 Mar 2005 - 10:07:25 EST


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



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Wed Mar 16 10:11:41 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:30:48 EST