similar to: RMySQL and RMPI together

Hi everybody! I have the next code which makes a reduction of the *a *variable in two slaves, using the Rmpi package. library(Rmpi) mpi.spawn.Rslaves(nslaves=2) reduc<-function(){ a<-mpi.comm.rank()+2 mpi.reduce(a,type=2, op="prod") return(paste("a=",a)) } mpi.bcast.Robj2slave(reduc) mpi.remote.exec(reduc()) cat("Product: ")

Hi everybody! I have the next code which makes a reduction of the *a *variable in two slaves, using the Rmpi package. library(Rmpi) mpi.spawn.Rslaves(nslaves=2) reduc<-function(){ a<-mpi.comm.rank()+2 mpi.reduce(a,type=2, op="prod") return(paste("a=",a)) } mpi.bcast.Robj2slave(reduc) mpi.remote.exec(reduc()) cat("Product: ")

Hi, I'm testing the efficiency of the Rmpi package regarding parallelization using a cluster. I've found and tried the task pull programming method, but even if it is described as the best method, it seems to cause deadlock, anyone could help me in using this method? here is the code I've found and tried: # Initialize MPI library("Rmpi") # Notice we just say "give us

Hi there. I see in a post from 2002 that you got the following problem with RMySQL: > con <- dbConnect(m) Process R segmentation fault at Wed Aug 28 08:21:11 2002 I have the same problem today: drv=dbDriver("MySQL") dbConnect(drv) # or with pretty much any other failing options Program received signal SIGSEGV, Segmentation fault. 0x00002b28d60c9fa0 in strlen () from

Hello, I have a problem.. I'm trying to make R communicate with MySQL, but I always receive an error.. My code is: library(DBI) library(RMySQL) drv <- dbDriver("MySQL") conn<-dbConnect(drv,username="####",password="####",dbname="prova",host="localhost") and I receive this message: Errore in function (classes, fdef, mtable) :

Hi, useR- In RMySQL, how do I overwrite records? (equivalent to "replace" query). For example, suppose that dat2 is a newer data.frame than dat1. con <- dbConnect(MySQL()) res <- dbWriteTable(con, "DBname", dat1, row.names=F, append=T, replace=T) res <- dbWriteTable(con, "DBname", dat2, row.names=F, append=T, replace=T) This would not update/replace the

Dear list, I learned how to connect R to a local MySQL server, using: drv <- dbDriver("MySQL") con <- dbConnect(drv, user="root", password="mypass", dbname="mydb") Is it possible to connect R in this way to an external server (on a different machine, with a different IP)? I read the documentation on ?dbConnect (and everything I could find on the

Hello, I have access to my database via command line and through workbench, and have access on the grant tables: mysql> SELECT host,user,password,select_priv,insert_priv FROM user; +------+-------+-------------------------------------------+-------------+-------------+ | host | user | password | select_priv | insert_priv |

Since there doesn't appear to be an RMySQL rpm for SuSE 8.*, does anyone know if the 7.3 version will work with the SuSE 8.2 rpms of R and DBI? The package installs without complaint, but when I try to run con <- dbConnect(dbDriver("MySQL"),dbname="test") I get the error Error in dbConnect(dbDriver("MySQL")) : couldn't find function

Being relatively new to R, I want to use R in connection with a MySQL database. After installing (apparently sucessfully) the package RMySQL (R Version 1.6.2) the result is as follows: > library(RMySQL) > con <- dbConnect(MySQL(), dbname= "test") Error: couldn''t find function "dbConnect" Thank You in advance for help Peter Jörg Peter Baresel Technische

I just installed RMySQL 0.5-9 with R 2.4.0 on Windows XP and got the following error message when trying to run a script with RMySQL: Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed < 2.0.0? Any ideas? Thanks, Frank

Hi all, I have experimented a segmentation fault error using RMySQL_0.4-6 library in R 1.5.1. Look the sequence: ------------------------------------------- > library(RMySQL) > m <- dbManager("MySQL") > m <MySQLManager:(1137)> > describe(m) <MySQLManager:(1137)> Driver name: MySQL Max connections: 10 Conn. processed: 0 Default records per

Full_Name: K?re Jonsson Version: 2.10 OS: WinXP Submission from: (NULL) (85.225.178.169) I made a brand new installation of R 2.10 in two machines and got the same problem. Machine 1 is Win XP on metal installation machine 2 is virtual in VMWare running a hacky OS named Tiny XP in which any Microsoft windows XP siftware always successfully is installed. Operation 1. Add package RMySQL from

Folks, I failed to create a connection to the database under MySQL DBMS in the R system via RMySQL's method dbConnection(...). My setup is as follows: Microsoft Windows XP 5.1.2600 MySQL 4.1.9 R 2.0.1 DBI 0.1-8 RMySQL 0.5-5 Both of DBI and RMySQL packages were downloaded from bell lab: http://stat.bell-labs.com/RS-DBI/download/index.html My case in R is as follows: > library(DBI)

Dear laurent, > This is what I did to make the connection : > > drv <- dbDriver("MySQL") > > con <- dbConnect(drv) Here's the error. You should give the database name. drv <-dbConnect(drv, dbname="dfghdfgsdfgsdfgsdfgsdfgsdfgsdf") ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > Then I should be able to send requests. But when I

Hello, I have trouble installing and loading the RMySQL package on OS X 2.8. The package seems to install from source fine (using R package manager from within the R environment). I have the following error when I try to load the package: loading package: RMySQL Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

Hi, I was able to connect to a MySQL database (called "zooscan" and with a table "serie" under Win XP with R 1.6.2 using: > library(DBI) > library(RMySQL) Warning message: DLL attempted to change FPU control word from 8001f to 9001f > drv <- dbDriver("MySQL") > con <- dbConnect(drv, dbname="zooscan") > dbExistsTable(con,

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 suse linux, with 1G RAM and with the code below it even fills the whole 1G of swap. I just

I don't use MySQL but I have seen messages like this before. They often have replies which indicate that you need to follow the instructions more closely. I suggest you search the list for these previous posts as I'm sure there is help there, somewhere! Tom > -----Original Message----- > From: Adriano von Sydow [mailto:pdasilva at xtra.co.nz] > Sent: Thursday, 10 March 2005 5:13

Dear users, I can access an database oracle database using sql developer. This was done by importing an xml file that contains the login details - username, password and specifies that it uses the KERBEROS_AUTHENTICATION. I'm trying to connect R - so that it can access this database - do sql queries and convert the resulting tables into dataframes. I am a novice in SQL and database access