similar to: Compressed communication with DB using RMySQL?

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)

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 connect hothand at localhost on dbname

I have justed upgraded R v1.7.0 on Windows NT 4 and have installed the latest RMySQL (version 0.5-1)and DBI (version 0.1-5) packages. When I issue the following commands (tactfully adjusted) R just crashes and disappears, any ideas? require(RMySQL) m <- dbDriver("MySQL") con <- dbConnect(m, dbname="xxx", user="xxx", password="xxx",

Quick question about the configuration files relative to RMySQL (I've tried to get feedback directly from the author David James, but his email address was non-responsive): Documentation at http://cran.r-project.org/doc/packages/RMySQL.pdf on page 3 indicates that for windows machines the only place that the my.cnf file will be looked for is the root (C:\) directory. Is this read correct?

Hi everybody, I'm having a problem with connecting to my MySQL database. Each time I try to connect library(RMySQL) m <- dbDriver("MySQL") con <- dbConnect (m, host="my_host",username="my_username", password="my_password", dbname="name_of_db") it says Fehler in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect

I have a local installation of MySQL on my computer. I enter the following to access MySQL from the command line: /Applications/MAMP/Library/bin/mysql -h localhost -u root -p I am then prompted for a password, and I use: root This connects me to MySQL in the command line. I now want to access MySQL databases in R. I enter the following: mysql <- dbDriver("MySQL") conn <-

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

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

Full_Name: Apfel Schmied Version: 2.8.1 (2008-12-22) OS: WinXP SP2 Submission from: (NULL) (134.106.122.139) RMySQL Version: 0.7-2 DBI Version: 0.2-4 MySQL Version: 5.1.30 (Enviroment Variable MYSQL_HOME is set) Updated R from 2.60 to 2.8.1. Now Gui.exe hangs up (100% CPU Useage) when requesting data from a mysql database. Example Code:

Hallo! Thanks for the answers that I received. I had downloaded the last distribution of RMySQL from /R/CRAN/src/contrib/Devel.. Its the first package that I am trying to compile under Windows. >From the Compiler I am getting the following error message. In file included from RMySQL.c:1: RMySQL.h:24: mysql.h: No such file or directory RMySQL.h:25: mysql_com.h: No such file or directory

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, I had my R to MySQL 5.0 connection working fine under 2.5.1 on Windows XP. My MySQL installation is local, not on a server and I could connect with: con <- dbConnect(MySQL(), dbname = "mydatabase", user="root", password="XX") I have updated to R 2.8.1 (RMySQL 0.7-2) but that same line of code yields: Error in mysqlNewConnection(drv, ...) : RS-DBI driver:

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, A newbie to R. I am trying to use the exonmap package in R. According to the docs, the xmapDatabase() command should read the config file with all the connection parameters and connect to the DB. But i get the error shown below.... > xmapDatabase("Human") Error in mysqlNewConnection(dbDriver(drv), ...) : RS-DBI driver: (could not connect cagadmin at mysql2.cag.chop.edu on

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

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 |

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 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 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

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,