I tried to install the RMySQL-library (R version 2.14.2, WinXP on 32bit) but got the following error message: install.packages("D:/R/library/RMySQL_0.9-3.tar.gz",repos=NULL, type="source") ... ...

I use RMySQL and a MySQL database to store my datasets. Sometimes data gets revised or I store results back to the database as well. Long story short, there is quite some interaction between R and ...

I'm trying to develop R shiny application using MySQL database. I'm trying to use PHP cloud and its MySQL database. And my Shiny application is in shiny cloud environment. I'm deploying my applicat...

I m trying to connect to a MySQL server on a VM from RMySQL, here are the commands i executed c<-dbConnect(MySQL(), user="root", password="passw0rd", dbname="leopard", host="one-1368") It is ...

I can't figure out why my RMySQL package won't install - here's what I get: > install.packages('RMySQL',type='source') trying URL 'http://cran.mirrors.hoobly.com/src/contrib/RMySQL_0.7-5.tar.gz...

Is it possible to pass a value into the query in dbGetQuery from the RMySQL package. For example, if I have a set of values in a character vector: df <- c('a','b','c') And I want to l...

I am making the move from RSQLite to RMySQL and I am confused by the user and password fields. FWIW, I'm running Windows 7, R 2.12.2, MySQL 5.5 (all 64 bit), and RMySQL 0.7-5. I installed RMySQL ...

I'm developing a web application using rapache and brew. Within the R code, I want to use the RMySQL package to query a MySQL database, but I am questioning the best way to access the login details...

I'm an R user, and I frequently find that I need to write functions that require subsetting large datasets (10s of millions of rows). When I apply such functions over a large number of observations...

This procedure works from the MySQL commandline both remotely and on localhost and it works when called from PHP. In all cases the grants are adequate: CREATE PROCEDURE `myDB`.`lee_expout` (IN e i...