[R] I can't do it again on an other PC : R+RMySQL ->error loading dll

Hello, Some weeks ago, thanks to you, I managed to install R, to connect to a local MySQL Database and to launch some queries with a script written with Tinn-R. My script is now ok and would like to test it with the "real" database. I did the same installation of R, DBI package and RMySQL packag

Re: [R] RMySQL loading error

This was just discussed: https://www.stat.math.ethz.ch/pipermail/r-help/2007-August/138142.html On 8/9/07, Clara Anton <[EMAIL PROTECTED]> wrote: > Hi, > > I am having problems loading RMySQL. > > I am using MySQL 5.0, R version 2.5.1, and RMySQL with Windows XP. > When I try to load rMySQL I ge

Re: [R] RMySQL loading error

On Thu, 9 Aug 2007, Clara Anton wrote: > Hi, > > I am having problems loading RMySQL. > > I am using MySQL 5.0, R version 2.5.1, and RMySQL with Windows XP. More exact versions would be helpful. > When I try to load rMySQL I get the following error: > > > require(RMySQL) > Loading required pack

[R] RMySQL loading error

Hi, I am having problems loading RMySQL. I am using MySQL 5.0, R version 2.5.1, and RMySQL with Windows XP. When I try to load rMySQL I get the following error: > require(RMySQL) Loading required package: RMySQL Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shar

[R] RMySQL configure.win error?

Hello, is there an error in the file configure.win from the package RMySQL_0.6-0.tar.gz, in the line dlltool --dllname ${MYSQL_LIB} --def libmysql.def --output-lib libmysql.a -k I think it must be dlltool --dllname ${MYSQL_DLL} --def libmysql.def --output-lib libmysql.a -k right? since MYSQ

Re: [R] RMySQL question, sql with R vector or list

> dynamically, rather than statically like using paste. One concern using > paste to construct the SQL command is this: what about if the ID list in > your sample becomes very large, is this a problem to construct this way? > I have not messed with procedures in mysql 5, so I have no idea about

Re: [R] RMySQL question, sql with R vector or list

007 1:49 PM > > To: Chris Stubben > > Cc: r-help@stat.math.ethz.ch > > Subject: Re: [R] RMySQL question, sql with R vector or list > > > > Thanks Chris. > > > > I think this should work. I have one more question regarding > > this. Is that > >

Re: [R] RMySQL question, sql with R vector or list

Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Waverley > Sent: Tuesday, June 05, 2007 1:49 PM > To: Chris Stubben > Cc: r-help@stat.math.ethz.ch > Subject: Re: [R] RMySQL question, sql with R vector or list > > Thanks Chris. > > I th

Re: [R] RMySQL question, sql with R vector or list

Thanks Chris. I think this should work. I have one more question regarding this. Is that possible to write some PL/SQL scripts integrated inside R, it is the same token like I have asked in my previous question. In this way, native R data structures can be passed to the MYSQL data base directly

Re: [R] RMySQL question, sql with R vector or list

> I am trying to write a RMySQL sql script inside R such that part of the SQL > would be R list or vector. For example, I want to select * from Atable > where ID would equal to a members of R list or vector of "1, 2, 3". Here > the ID list was generated inside R and then try to feed to mysql to

[R] RMySQL question, sql with R vector or list

Hi, I am trying to write a RMySQL sql script inside R such that part of the SQL would be R list or vector. For example, I want to select * from Atable where ID would equal to a members of R list or vector of "1, 2, 3". Here the ID list was generated inside R and then try to feed to mysql to call

[R] RMySQL loading error, mysql in path

I have successfully installed RMySQL_0.6-0 using under Windows XP MCE, I am using MySQL 5.0.41, I have added I have added C:\Program Files\R\R-2.4.1\library\RMySQL\libs and mysql to the windows PATH, but again, same error: and then when I load R and try to use RMySQL >library(RMySQL) Error

Re: [R] RMySQL DBI question

Hi, It would be helpful to have a small reproducible example. Do you see the same error if you run "R --save < whatever.R" from the shell prompt? Regards, -- David On 5/31/07, Waverley <[EMAIL PROTECTED]> wrote: > Dear colleague, > > I have two data frame which I tried to use dbWriteTable fun

[R] RMySQL DBI question

Dear colleague, I have two data frame which I tried to use dbWriteTable function with append=TRUE to write to the mysql database. The problem is that if I am run my R script directly then it is fine. Both data frame got written into the database. But when I tried to embed the script to be calle

Re: [R] RMySQL *was* working...

Pete Cap <[EMAIL PROTECTED]> writes: > List, > > Last week with the help of Uwe and some other folks I was able to get > RMySQL 0.5-7 compiled against R 2.4.1 and MySQL 5.0.27. It was > working fine--I was able to send select queries to the db, put the > results in a data frame, and so forth. > >

Re: [R] RMySQL *was* working...

List, Please disregard. I merely forgot the quotes: > dbDriver("MySQL") Thanks, Pete Pete Cap <[EMAIL PROTECTED]> wrote: List, Last week with the help of Uwe and some other folks I was able to get RMySQL 0.5-7 compiled against R 2.4.1 and MySQL 5.0.27. It was working fine--I was able to se

[R] RMySQL *was* working...

List, Last week with the help of Uwe and some other folks I was able to get RMySQL 0.5-7 compiled against R 2.4.1 and MySQL 5.0.27. It was working fine--I was able to send select queries to the db, put the results in a data frame, and so forth. Today, dbDriver() threw an error: > dbDriver(My

Re: [R] RMySQL load error

I got some great help from Phil Spector on how to solve this: export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib/mysql and/or add this to the /usr/bin/R script. Life is good, Dick *** Richard P. Beyer, Ph.D. Universi

[R] RMySQL load error

I'm having trouble getting RMySQL to load. I was able to build it and install it (RMySQL_0.5-11.tar.gz). I was also able to build and install mysql-5.0.37. I've read many postings about this but have not found a mention of my particular problem (some closely related). I get the "unable to loa

Re: [R] RMySQL on win32

Uwe Ligges <[EMAIL PROTECTED]> wrote: If you have gcc installed, yes, still a path issue: You have tp put MinGW's ./bin directory into your PATH. Best, uwe Uwe, Got it. I had placed ..\mingw\mingw32\bin in the path instead. I also had to place the directory for the HTML Help Workshop in the

Re: [R] RMySQL on win32

If you have gcc installed, yes, still a path issue: You have tp put MinGW's ./bin directory into your PATH. Best, uwe Pete Cap wrote: > */Uwe Ligges <[EMAIL PROTECTED]>/* wrote: > > Please follow the Instructions to set up your build environment as > mentioned in the R Installation and

Re: [R] RMySQL on win32

Uwe Ligges <[EMAIL PROTECTED]> wrote: Please follow the Instructions to set up your build environment as mentioned in the R Installation and Administration manual. That includes installing the tools from Duncan Murdochs Webpage and putting it into your path. You either forgot to install those t

Re: [R] RMySQL on win32

Pete Cap wrote: > List, > > I am still unable to compile RMySQL on XP and would appreciate any assistance > anyone could provide. > > I know that setting up RMySQL on win32 is not easy. The installation > instructions are supposedly contained in ../src/README.win. They give > instructions

Re: [R] RMySQL on win32

Pete Cap <[EMAIL PROTECTED]> writes: > List, > > I am still unable to compile RMySQL on XP and would appreciate any > assistance anyone could provide. > > I know that setting up RMySQL on win32 is not easy. The > installation instructions are supposedly contained in > ../src/README.win. They giv

Re: [R] RMySQL on win32

Pete Cap <[EMAIL PROTECTED]> writes: > List, > > I am still unable to compile RMySQL on XP and would appreciate any > assistance anyone could provide. > > I know that setting up RMySQL on win32 is not easy. The installation > instructions are supposedly contained in ../src/README.win. They give

Re: [R] RMySQL on win32

List, I am still unable to compile RMySQL on XP and would appreciate any assistance anyone could provide. I know that setting up RMySQL on win32 is not easy. The installation instructions are supposedly contained in ../src/README.win. They give instructions on creating a file, libmysql.a, wh

Re: [R] RMySQL on win32

Hello I try to compile RMysql and ROracle for Windows XP with Visual C++ but I haven´t successed. Finally I have used RJDBC and it works. Jose Sierra. Uwe Ligges escribió: > Pete Cap wrote: > >> List, >> >> I just left an environment where I was running R and mysql on CENTOS. >> At the

Re: [R] RMySQL on win32

Pete Cap wrote: > List, > > I just left an environment where I was running R and mysql on CENTOS. > At the time of install, RMySQL was available on CRAN. Later installs > on Ubuntu were possible because it was available as a package in the > base repos. > > Now I'm in a new environment where I

[R] RMySQL on win32

List, I just left an environment where I was running R and mysql on CENTOS. At the time of install, RMySQL was available on CRAN. Later installs on Ubuntu were possible because it was available as a package in the base repos. Now I'm in a new environment where I have no choice but to use Wind

Re: [R] RMySQL connection

On Fri, 2007-01-19 at 09:02 +, qing Jing wrote: > Dear All, > > What's wrong? > I am runningR 2.1.1 DBI 0.1-9 RMySQL 0.5-6 Windows XP I'd start with updating your R installation to something less archaic - yours is at least 18 months out of date. La

[R] RMySQL connection

Dear All, What's wrong? > library(DBI); > library(RMySQL); > mgr<-dbDriver("MySQL"); > con<-dbConnect(mgr,dbname="test"); Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect (null)@(null) on dbname "test") I also tried another example > library(RMySQL); > myco

Re: [R] RMySQL adn FC6 - install fail

R Gott wrote: (With a name like that you'd better get good at this) ;-) > Dear anybody > > I am running Fedora Core 6 with the latest version of R. > > When I try to install the package RMySQL I get this message: > > * Installing *source* package 'RMySQL' ... > creating cache

[R] RMySQL adn FC6 - install fail

Dear anybody I am running Fedora Core 6 with the latest version of R. When I try to install the package RMySQL I get this message: * Installing *source* package 'RMySQL' ... creating cache ./config.cache checking how to run the C preprocessor... /lib/cpp checking

[R] RMySQL

options(CRAN='http://cran.r-project.org') install.packages("RMySQL", type="source") Warning: unable to access index for repository http://www.ibiblio.org/pub/languages/R/CRAN/src/contrib Warning: unable to access index for repository http://www.stats.ox.ac.uk/pub/RWin/src/contrib Warnin

Re: [R] RMySQL Suse 10.0 installing problems

On Thu, 6 Jul 2006, H. Paul Benton wrote: > Thanks again everyone, > I have a problem trying to install RMySQL on Suse 10.0. I have used > both the install.packages() and the 'R CMD INSTALL RMySQL..." neither > worked. I get the error message telling me that it cannot find mysql. So I > have

[R] RMySQL Suse 10.0 installing problems

Thanks again everyone, I have a problem trying to install RMySQL on Suse 10.0. I have used both the install.packages() and the 'R CMD INSTALL RMySQL..." neither worked. I get the error message telling me that it cannot find mysql. So I have set the flags using export PKG_CPPFLAGS="-I" exp

Re: [R] RMySQL...Can't initialize driver??? Solved!!!

Hi, I have finally made it working. I do not if that was the problem but the libraries (DBI and RMySQL) were installed in a non-standard location (of course specified in a .Renviron file). Reinstalling both of them at R root did the trick... thanks to you all for your help... Stephane. Rainer

Re: [R] RMySQL...Can't initialize driver???

Stephane Cruveiller wrote: > Rainer M Krug wrote: > I followed your instruction. Here is my .my.cnf: > --- > [client] > user=steff > password=XX > database=justforfun > --

Re: [R] RMySQL...Can't initialize driver???

This looks very suspicious. The function mysqlInitDriver is pretty straight forward (see below), but the error you're reporting apparently has something to do with S4 dispatching: > mysqlInitDriver function (max.con = 16, fetch.default.rec = 500, force.reload = FALSE) { if (fetch.defa

Re: [R] RMySQL...Can't initialize driver???

Rainer M Krug wrote: Stephane Cruveiller wrote: Duncan Murdoch wrote: On 6/27/2006 8:51 AM, Stephane Cruveiller wrote: Dear R users, I would like to query a MySQL database through R. I have installed the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL server (v

Re: [R] RMySQL...Can't initialize driver???

Stephane CRUVEILLER wrote: > Dear R users, > > I would like to query a MySQL database through R. I have installed > the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL > server (v5.0.22) is running on my local machine but I can't initialize MYSQL > driver: >

Re: [R] RMySQL...Can't initialize driver???

Stephane Cruveiller wrote: > Duncan Murdoch wrote: >> On 6/27/2006 8:51 AM, Stephane Cruveiller wrote: >>> Dear R users, >>> >>> I would like to query a MySQL database through R. I have installed >>> the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL >>> server (v5.0.22) is runnin

Re: [R] RMySQL...Can't initialize driver???

On 6/27/2006 8:51 AM, Stephane Cruveiller wrote: > Dear R users, > > I would like to query a MySQL database through R. I have installed > the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL > server (v5.0.22) is running on my local machine but I can't initialize > MYSQL > driver:

Re: [R] RMySQL...Can't initialize driver???

Duncan Murdoch wrote: On 6/27/2006 8:51 AM, Stephane Cruveiller wrote: Dear R users, I would like to query a MySQL database through R. I have installed the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL server (v5.0.22) is running on my local machine but I can't initialize MY

[R] RMySQL...Can't initialize driver???

Dear R users, I would like to query a MySQL database through R. I have installed the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL server (v5.0.22) is running on my local machine but I can't initialize MYSQL driver:

[R] RMySQL...Can't initialize driver???

Dear R users, I would like to query a MySQL database through R. I have installed the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL server (v5.0.22) is running on my local machine but I can't initialize MYSQL driver: -

Re: [R] RMySQL on Mac OS 10.4

Ryan Hafen <[EMAIL PROTECTED]> writes: > > dbWriteTable(con, "test", rnorm(100)) > Error in .class1(object) : no direct or inherited method for function > 'dbWriteTable' for this call > > For more info, I am running OS X 10.4.6, R 2.2.1, I have compiled > RMySQL from source version 0.5-7, and

[R] RMySQL on Mac OS 10.4

I have been having trouble getting RMySQL to work on Mac OS 10.4. It was working fine for me about a year ago but I didn't touch it for a while and several upgrades of R, MySQL, and OS X later, it is not working. I first had the problem that others have been having getting the error discu

Re: [R] RMySQL loading error

but of course; danke. -P Prof Brian Ripley wrote: > On Wed, 17 May 2006, Patrice Seyed wrote: > >> i was able to install DBI and RMySQL cleanly. I get the error below on >> "library('RMySQL')". >> >> The file it is complaining about is located in /usr/lib/mysql/, where is >> R trying to load it fr

Re: [R] RMySQL loading error

On Wed, 17 May 2006, Patrice Seyed wrote: > i was able to install DBI and RMySQL cleanly. I get the error below on > "library('RMySQL')". > > The file it is complaining about is located in /usr/lib/mysql/, where is > R trying to load it from? Tried a symlink into /usr/local/lib/mysql to > no avail

[R] RMySQL loading error

i was able to install DBI and RMySQL cleanly. I get the error below on "library('RMySQL')". The file it is complaining about is located in /usr/lib/mysql/, where is R trying to load it from? Tried a symlink into /usr/local/lib/mysql to no avail. thx. -P Loading required package: DBI Error in d

Re: [R] R, RMysql, and MySQL 5 Decimal Type Support

o:[EMAIL PROTECTED] Sent: Tuesday, March 28, 2006 11:08 PM To: Jason Trimble Cc: r-help@stat.math.ethz.ch Subject: Re: [R] R, RMysql, and MySQL 5 Decimal Type Support Hi, MySQL data type 246 is the new (as of version 5.0?) fixed precision DECIMAL type, which doesn't map to any existing R type.

Re: [R] R, RMysql, and MySQL 5 Decimal Type Support

Hi, MySQL data type 246 is the new (as of version 5.0?) fixed precision DECIMAL type, which doesn't map to any existing R type. In most cases, I believe, it is imported as an R character vector, and you can just coerce it to numeric, i.e., to floating point precision. Next version of RMySQL will

Re: [R] R, RMysql, and MySQL 5 Decimal Type Support

artment of Physiology A. T. Still University of Health Science 800 W. Jefferson St. Kirksville, MO 63501-1497 USA - Original Message - From: "Jason Trimble" <[EMAIL PROTECTED]> To: Sent: Tuesday, March 28, 2006 12:08 PM Subject: [R] R, RMysql, and MySQL 5 Decimal Type Support

[R] R, RMysql, and MySQL 5 Decimal Type Support

Hi, Whenever I have a MySQL query that returns a Decimal result to R I get the following warning in R: Warning message: RS-DBI driver warning: (unrecognized MySQL field type 246 in column 1) I get this for a simple query like "SELECT 2, 2.5" !! I am using: R ver 2.1.1 RMySQL ver.

Re: [R] RMySQL Error Messages, crashing R

Phil, Thanks for the tip. I have tried rebuilding the RMySQL library, but it always fails. When I run: R CMD INSTALL --configure-args='--with-mysql-inc=/usr/local/mysql/ include --with-mysql-lib=/usr/local/mysql/lib' /Users/jason/Desktop/ RMySQL_0.5-7.tar.gz.tar I get ... gcc-3.3 -bundle

[R] RMySQL Error Messages, crashing R

I am having trouble getting RMySQL working with R. It did at one point, work with an older 1.x version of R, but now with R2.2.1, I am getting the following messages on my OS X 10.4.5 system: RS-DBI driver warning: (MySQL mismatch between compiled version 4.0.24 and runtime version 4.1.14)

[R] RMySQL problem with more than 1 field

I am trying to use R (version 2.2.1) to extract and analyse data from a MySQL database on Mac OS X 10.4.4. I've installed DBI and RMySQL, and it all works fine when I try to extract a single field of data, but when I try to extract more than one field R crashes and has to be restarted. Th

Re: [R] RMySQL install

Received some excellent responses to my query. The problem was with the mysql-devel libraries. I upgraded/installed the mysql client/server/devel libraries to 4.1.16 and issued the "well known" fixes of : export PKG_LIBS='-L/usr/lib64/mysql -lmysqlclient' export PKG_CPPFLAGS=-I/usr/in

Re: [R] RMySQL install

Michaell Taylor wrote: > > I am having trouble installing RMySQL on a clean install of Fedora Core 4 64 > bit on a dual dual core machine (that is, two dual core processors). Seems > like the LD_LIBRARY_PATH is incorrect, but I don't seem to have it quite > right yet. > > There are a few men

Re: [R] RMySQL install

Michaell Taylor <[EMAIL PROTECTED]> writes: > I am having trouble installing RMySQL on a clean install of Fedora Core 4 64 > bit on a dual dual core machine (that is, two dual core processors). Seems > like the LD_LIBRARY_PATH is incorrect, but I don't seem to have it quite > right yet. > >

[R] RMySQL install

I am having trouble installing RMySQL on a clean install of Fedora Core 4 64 bit on a dual dual core machine (that is, two dual core processors). Seems like the LD_LIBRARY_PATH is incorrect, but I don't seem to have it quite right yet. There are a few mentions of this problem in google, but

[R] RMySQL/DBI

Hello, does anybody run RMySQL/DBI successfully on SunOS5.8 and MySQL 3.23.53 ? I'll get a segmentation fault whe trying to call dbConnect. We'll soon swtich to MySQL 4, however, I was wondering whether the very ancient mysql version realy is the problem ... RMySQL 0.5-5 DBI 0.1-9 R 2.2.0 Su

[R] rmysql installed but unable to load

Hi, First off here is my system configuration: Dual 2.3 Ghz PowerPC G5 Mac OS X 10.4.3 R for Mac OS X Aqua GUI 1.12 (installed in default location) Mysql 5.0.13 located in: /usr/local/mysql-max-5.0.13-rc-osx10.4-powerpc/ and default version in /usr/local/mysql I downloaded RMySQL_0.5-5.tar.gz

Re: [R] RMySQL problems

Hi, i have recently same problems, but when i add a new user without password it works, but i could not recognize why the user with password didn't work. After a new mysql (Win-XP mysqll 5.0.13 rc ) installation it works normal. regards, christian DBI version 0.1-9 RMySQL 0.5-5 _

[R] RMySQL problems

I get the following error trying to connect to a MySQL database: > library(RMySQL) Loading required package: DBI > drv<-dbDriver("MySQL") > con<-dbConnect(drv, user="hothand", password=xxx, host="localhost", dbname="hh03"); Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not c

Re: [R] RMySQL installation problem on FC4 x86_64

On 7 Sep 2005, [EMAIL PROTECTED] wrote: > # yum list installed mysql > Installed Packages > mysql.i3864.1.11-2 installed > mysql.x86_64 4.1.11-2 installed I would have thought that you need to have a mysql-dev.x86_64 rpm package installed in order to

[R] RMySQL installation problem on FC4 x86_64

Dear useRs, I'm having a hard time installing RMySQL on a FC4 x86_64 box (R 2.1.0 and MySQL 4.1.11-2 installed through yum). After an initial configuration error ("could not find the MySQL installation include and/or library directories") I managed to install RMySQL with # export PKG_LIBS="-L -

Re: [R] RMySQL not loading on Mac OS X

On 18/08/2005, at 7:46 PM, Georg Otto wrote: > Concerning your suggestion: The system default compiler is gcc 4.0, > but RMySQL seems to be built using gcc-3.3 regardless if I switch > to 3.3. or not. > > Would it be a solution to force RMySQL to use gcc 4.0 during built? > (Might be a naive

Re: [R] RMySQL not loading on Mac OS X

Bill, thanks a lot for your answer. I did not know about the sig-Mac list. I will post there next time if I do not find a solution. Concerning your suggestion: The system default compiler is gcc 4.0, but RMySQL seems to be built using gcc-3.3 regardless if I switch to 3.3. or not. Would it

Re: [R] RMySQL not loading on Mac OS X

On 11/08/2005, at 8:00 PM, Georg Otto wrote: > I have a problem loading RMySQL 0.5-5 on Mac OS 10.4.2 running R > 2.1.1. > > I installed RMySQL using: > > export PKG_CPPFLAGS="-I/usr/local/mysql/include" > export PKG_LIBS="-L/usr/local/mysql/lib -lmysqlclient" > > R CMD INSTALL /Users/gwo/Desktop

[R] RMySQL not loading on Mac OS X

Hi, I have a problem loading RMySQL 0.5-5 on Mac OS 10.4.2 running R 2.1.1. I installed RMySQL using: export PKG_CPPFLAGS="-I/usr/local/mysql/include" export PKG_LIBS="-L/usr/local/mysql/lib -lmysqlclient" R CMD INSTALL /Users/gwo/Desktop/RMySQL_0.5-5.tar.gz The installation seemed to work ok

Re: [R] RMySQL typing Problem (bigint unsigned)

On 7/4/2005 9:50 AM, Dubravko Dolic wrote: > Dear Group, > > > > if anyone has experience with the RMySQL Package maybe this behaviour is know: > > > > Reading data from a table into R the fields with datatype bigint(20) unsigned > are transformed in some way: e.g. the query "select * from

[R] RMySQL typing Problem (bigint unsigned)

Dear Group, if anyone has experience with the RMySQL Package maybe this behaviour is know: Reading data from a table into R the fields with datatype bigint(20) unsigned are transformed in some way: e.g. the query "select * from orders where userid = 14929859848712890325" selects the corre

Re: [R] RMySQL installation: libz missing SOLVED

Hi, do you have zlib installed on your system? (rpm -q zlib tells you if or not) You can also try rpm -q --whatprovides libz . zlib provides libz. If not installed, the manual compilation of R uses its own version of zlib, if I understand it correctly. So, not really a problem with the rpm.

Re: [R] RMySQL installation: libz missing SOLVED

it seemed to be a problem with the rpm for suse 9.1.. I installed and compiled R2.1 using the sources, then installation of RMySQL succeeded mmmh .. Christoph Christoph Lehmann wrote: Hi I run suse linux 9.1 and I installed MySQL server, client, devel, bench. DBI is installed, when I try to insta

Re: [R] RMySQL installation: libz missing

hi christoph i had the same problem recently, i ended up finding that the following linux packages were missing (or at least one of them). php4-mysql php5-mysql php5-mysqli maybe that helps, sebastian On Tuesday 03 May 2005 12:54, Christoph Lehmann wrote: > Hi > I run suse linux 9.1 and I insta

[R] RMySQL installation: libz missing

Hi I run suse linux 9.1 and I installed MySQL server, client, devel, bench. DBI is installed, when I try to install RMySQL I get an error saying, that libz is missing. (paths to libs were set:export PKG_CPPFLAGS="-I/usr/include/mysql/" export PKG_LIBS="-L/usr/lib/mysql/ -lmysqlclient") so my ques

Re: [R] RMySQL query: why result takes so much memory in R ?

Hi, IMHO you need only when your columns are numeric X rows /100/100/8 MB. >>(1200*3)/100/100/8 [1] 450 But one of your columns is group char. I'm suffering in the past in lot of things with massive data and R and recognize doing how many as possible in the database, or you have to upgrade

Re: [R] RMySQL query: why result takes so much memory in R ?

Christoph Lehmann wrote: Hi I just started with RMySQL. I have a database with roughly 12 millions rows/records and 8 columns/fields. From all 12 millions of records I want to import 3 fields only. The fields are specified as:id int(11), group char(15), measurement float(4,2). Why does this tak

[R] RMySQL query: why result takes so much memory in R ?

Hi I just started with RMySQL. I have a database with roughly 12 millions rows/records and 8 columns/fields. From all 12 millions of records I want to import 3 fields only. The fields are specified as:id int(11), group char(15), measurement float(4,2). Why does this take > 1G RAM? I run R on sus

Re: [R] RMySQL question

simone gabbriellini wrote: > Dear List, > I have this little problem: > > I work with adiacency matrix like: > > data me you > me0 1 > you 1 0 > > I store those matrix in a mysql database > > actually I use RMySQL with: > > res<-dbSendQuery(connection, "SELECT * FROM table")

Re: [R] RMySQL question

Use the rownames() function to set the rownames equal to your first column, and then drop the first column. I don't know if there is a way to do it during retrieval from MySQL. -Don At 11:10 PM +0200 4/2/05, simone gabbriellini wrote: Dear List, I have this little problem: I work with adiacency m

[R] RMySQL question

Dear List, I have this little problem: I work with adiacency matrix like: datame you me 0 1 you 1 0 I store those matrix in a mysql database actually I use RMySQL with: res<-dbSendQuery(connection, "SELECT * FROM table") myDataFrame<-fetch(res) to retrive the table, and I h

Re: [R] "RMySQL for R 2.0.1"

Fredrik Lundgren wrote: > Dear List, > > RMySQL is old and wouldn't install on R 2.0.1. > How should the source be rewritten to be accepted by R 2.0.1. > > With thanks > > Fredrik Lundgren > > __ > R-help@stat.math.ethz.ch mailing list > https://stat.

[R] "RMySQL for R 2.0.1"

Dear List, RMySQL is old and wouldn't install on R 2.0.1. How should the source be rewritten to be accepted by R 2.0.1. With thanks Fredrik Lundgren __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the p

Re: [R] RMySQL installed but not availalable

require(RMySQL) help('MySQL') then see the examples shown by the help page At 9:12 PM -1200 3/9/05, Adriano von Sydow wrote: Hi I run Linux SuSE 9.1, with MSQL 4.0.18 I installed R 2.0.1 and it is working fine I installed RM 0.5-5 package and verified all installed.packages (see below) but when I

Re: [R] RMySQL installed but not availalable

Thanks Arne, that was spot on. Cheers, Popolito Arne Henningsen wrote: Did you _load_ the package? R> library( RMySQL ) On Thursday 10 March 2005 10:12, Adriano von Sydow wrote: Hi I run Linux SuSE 9.1, with MSQL 4.0.18 I installed R 2.0.1 and it is working fine I installed RM 0.5-5 package and

Re: [R] RMySQL installed but not availalable

Did you _load_ the package? R> library( RMySQL ) On Thursday 10 March 2005 10:12, Adriano von Sydow wrote: > Hi > I run Linux SuSE 9.1, with MSQL 4.0.18 > I installed R 2.0.1 and it is working fine > I installed RM 0.5-5 package and verified all installed.packages (see > below) but when I tried to

RE: [R] RMySQL installed but not availalable

e- > From: Adriano von Sydow [mailto:[EMAIL PROTECTED] > Sent: Thursday, 10 March 2005 5:13 PM > To: r-help@stat.math.ethz.ch > Subject: [R] RMySQL installed but not availalable > > > Hi > I run Linux SuSE 9.1, with MSQL 4.0.18 > I installed R 2.0.1 and it is working

[R] RMySQL installed but not availalable

Hi I run Linux SuSE 9.1, with MSQL 4.0.18 I installed R 2.0.1 and it is working fine I installed RM 0.5-5 package and verified all installed.packages (see below) but when I tried to use any RMySQL specific comand is gives me the same error messages > dbConnect Error: Object "dbConnect" not found

[R] RMySQL vs. Rdbi

Hello, I know that the topics of using large datasets in R vs. SAS, using PostGreSQL vs MySQL, and using databases with R have been discussed extensively on this list and elsewhere. However I hope that I have a slightly new combination of the questions here. I am doing my PhD research on a larg

Re: [R] RMySQL connection

The problem has been solved. I didnt install the mysql libraries and header files properly. To solve it, I installed: MySQL-client-4.1.7-0.i386.rpm MySQL-server-4.1.7-0.i386.rpm AND MySQL-devel-4.1.7-0.i386.rpm (libraries and header files) then I installed RMySQL using: export PKG_CPPFLAGS="-I/u

Re: [R] RMySQL connection

On Oct 28, 2004, at 4:37 AM, R.Alberts wrote: Hi, I cannot connect to my mysql database from within R using RMySQL. What am I doing wrong? I use linux SuSe 8.1 and R-2.0.0 RMySQL_0.5-5.tar.gz DBI_0.1-8.tar.gz I get the following error in R: library(RMySQL) Loading required package: DBI m <- dbDri

[R] RMySQL connection

Hi, I cannot connect to my mysql database from within R using RMySQL. What am I doing wrong? I use linux SuSe 8.1 and R-2.0.0 RMySQL_0.5-5.tar.gz DBI_0.1-8.tar.gz I get the following error in R: library(RMySQL) Loading required package: DBI m <- dbDriver("MySQL") m con <- dbConnect(m, group = "m

Re: [R] RMySQL and Blob

ting dumping the images to files and then importing them with the pixmap library seems quite reasonable to me. Regards, -- David > > Thanks for suggestions! > Jonathan > > > > > > -Original Message- > From: David James [mailto:[EMAIL PROTECTED]

Re: [R] RMySQL and Blob

"rs" as a binary object as you suggested. Any ideas? Thanks for suggestions! Jonathan -Original Message- From: David James [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 10:06 AM To: LI,JONATHAN (A-Labs,ex1) Cc: David James Subject: Re: [R] RMySQL and Blob [EMAIL PROTEC

RE: [R] RMySQL and Blob

Any ideas? Thanks for suggestions! Jonathan -Original Message- From: David James [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 10:06 AM To: LI,JONATHAN (A-Labs,ex1) Cc: David James Subject: Re: [R] RMySQL and Blob [EMAIL PROTECTED] wrote: > Hi David, > > Th

RE: [R] RMySQL and Blob

ECTED] Subject: Re: [R] RMySQL and Blob Hi Jonathan, Currently RMySQL doesn't handle blob objects. The mechanics of inserting and extracting blob objects by itself is not too hard, but issues such as how should blobs be made available to R, how to prevent buffers overflows, how to prevent

Re: [R] RMySQL and Blob

Hi Jonathan, Currently RMySQL doesn't handle blob objects. The mechanics of inserting and extracting blob objects by itself is not too hard, but issues such as how should blobs be made available to R, how to prevent buffers overflows, how to prevent huge blobs from exhausting the available memory

  1   2   >