I am running an Rscipt which calculates economic parameters for around 1000 cities in a loop. The data is stored in MySQL which I am accessing using RMySQL and DBI packages.
However I keep getting segmentation fault errors. I have no idea why this…
I am using RMySQL to connect to an aws MySQL server. It works, except character values are deformed. This question has been asked before but the fixes don't seem to work for me. Here's what I'm doing:
Make sure no connections are…
I have been looking for a guide to install R-Script and (in particular) RMySQL on a laravel homestead vagrant box. However the documentation I have found has either been for windows OS's or has failed before installing the RMySQL package.
So my…
I seem to be doing something wrong when trying to use setDefaults. If I enter each argument every time I use getSymbols.MySQL, it seems to work fine but I get an error when doing the following:
> setDefaults(getSymbols.MySQL,
user =…
I'm trying to set up the initial database connection between R and MySQL. I installed RMySQL. When I try to connect to my database, this is the error I receive.
Any direction in fixing it is much appreciated! The package is still quite new so help…
I am using a Mac. I successfully installed XAMPP. I also have installed RMySQL in R. I created a database in XAMPP. I now want to connect to this database in R. Assuming the database is called name, I have tried:
conn <- dbConnect(MySQL(),…
Would appreciate any tips regarding how to close MySQL connections in R.
Used dbDisconnect(), but it kept throwing an error:
Error in (function (classes, fdef, mtable) : unable to find an
inherited method for function 'dbDisconnect' for…
I am unable to fetch all rows from mysql using R.
There are around 900000 rows need to fetch but R is fetching only around 500000 rows. I am getting below warning.
> response = fetch(res ,1000000)
Warning message:
In is(object, Cl) : error…
A call to dbColumnInfo takes > 5 min for a table, and a substantial amount of traffic (~ 35 mbps). The table is big:
> dbGetQuery(connRemoteDB, statement = "select count(*) from bidders")
count(*)
1 77850272
but since dbColumnInfo does not return…
I have a string variable called time which holds the time value like:
time = "2015.03.04";
I would like to pass this variable into mysql to retrieve information
rs <- dbSendQuery(mydb, "SELECT * FROM TIMETABLE WHERE Time LIKE",time,"…
I am reading and writing from MySQL tables which have utf8 encoding and a mix of numerical fields and text fields of Japanese characters. The tables can be read without problem and display properly in R but writing back to MySQL using dbWriteTable…
I am trying to install RMySQL on Windows 7 using R version 2.15.1.
and I followed the instructions from http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/ and another StackOverflow posts but I get this error over and over:
**…
I have an R script where I want to pull some data from a MySQL database, then from a PostgreSQL database. However, loading the MySQL driver from RMySQL prevents me from loading the PostgreSQL driver from PostgreSQL.
I can load the Postgres driver…
I'm fairly new to R, so forgive me if this is a amateur question. I still don't get parts of how the R language works and I haven't used closures enough to really build intuition on how to approach this problem.
I want to wrap up opening and closing…
I am trying to connect to a MySQL server through R and it works perfect with the follwoing line:
con <- dbConnect(MySQL(), user="user", password="password",dbname="dbname", host="localhost", port=3306)
But, I would like to use a cnf file so that my…
