search for: dbwrite

Hi I'm using the dbwrite to insert a large dataset. There are about 10 million rows. But i'm not able to load the records. Please can anyone tell me the way to load or maximum number of records that dbwrite does. so that i can load it in batches ----- Thanks in Advance Arun -- View this message in context: ht...

hi I need some help in dbWriteTable. I'm not able to insert the rows in the table if the column order are not same in the database and in the dataframe which i'm inserting. Also facing issue if the table is already created externally and inserting it thru dbWrite. is there some way that we can sepecify the rownames in...

...ctTables package (added a NAMESPACE file) to reproduce the problem: devtools::install_github("jeroenooms/RObjectTables") The problem can be triggered using the included example from the DirectoryObjectTable manual. library(RObjectTables) db <- DirectoryObjectTable(tempdir()) dbwrite(db, "x", 1:10) dbwrite(db, "y", letters[1:3]) dbobjects(db) dbread(db, "x") attach(newRFunctionTable(db), name = "myRData") Things work as expected up till dbread(), but once the object-table is attached, R freezes on 32bit whereas it works as expect...

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