Re: [R] Install the RMySQL

From: Ko,Younhee <>
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 <>
>Subject: Re: [R] Install the RMySQL
>To: "Ko,Younhee" <>
>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-
>> 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
>> RS-MySQL.h:42:23: mysql_com.h: No such file or directory
>That's sufficient info.
>Brian D. Ripley,
>Professor of Applied Statistics,
>University of Oxford, Tel: +44 1865 272861
>1 South Parks Road, +44 1865 272866 (PA)
>Oxford OX1 3TG, UK Fax: +44 1865 272595

Younhee Ko(
contact : 217-417-4868
Graduate Student in Dept. of Computer Science University of Illinois at Urbana-Champaign mailing list PLEASE do read the posting guide! 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