search for: mysqlwritet

Hi, Can somebody advice on weird mysqlWriteTable bug. > mysqlWriteTable(conn, 'comparison',design2, row.names = F, overwrite=T) Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the...

Hi, i getting following error and don't know doing something wrong. >mysqlWriteTable(con,"model1",model1,overwrite=T) Error in "[.data.frame"(value, from:to, drop = FALSE) : undefined columns selected In addition: Warning message: drop argument will be ignored in: "[.data.frame"(value, from:to, drop = FALSE) Exactly the same code, database...

...fails Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( x bigint )' at line 2) [1] FALSE Warning message: In mysqlWriteTable(conn, name, value, ...) : could not create table: aborting mysqlWriteTable > dbGetQuery(con, "create temporary table x ( x int);") # workaround NULL > dbWriteTable(con, "x", x, verbose=TRUE,row.names=FALSE, overwrite=T) [1] TRUE > dbGetQuery(con, "select * fr...

...frame using something like: dbWriteTable(con, "contact", dat, append=TRUE) However, I get this error: Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: Unknown column 'row_names' in 'field list') [1] FALSE Warning message: In mysqlWriteTable(conn, name, value, ...) : could not load data into table Can anyone shed light on this error, or how I might bulk load this data using RMySQL? Cheers, Nathan -- -------------------------------------------------------- Dr. Nathan S. Watson-Haigh OCE Post Doctoral Fellow CSIRO Livestock Indu...

...dTable(con,"test") > aa x y 1 0 0 2 0 0 > # and this is clearly not what we want... # # as a crude patch I added for (i in 1:length(value)) if (class(value[[i]])=="logical") class(value[[i]])<-"integer" # before i <- match("row.names", ... in mysqlWriteTable # but others have much more talent in writing clean code than I ... # > mysqlWriteTablecrudepatch(con,"test",a,overwrite=TRUE) [1] TRUE # and > aa<-dbReadTable(con,"test") > aa x y 1 1 0 2 0 1 # and this IS what we want. platform i386-pc-mingw32 arch i38...

...p the data frame into a MySQL database everything works fine except the names of these three columns which are slightly different (e.g. 'DateTime_9'). This only occurs with these 3 columns because their names are reserved words of MySQL. The change of names is occurring in the function mysqlWriteTable, namely in the call: ... names(field.types) <- make.db.names(con,names(field.types),allow.keywords=F) ... If I change the parameter allow.keywords into T, everything works fine for me. Given that MySQL allows all characters to be part of field names (section 6.1.2 of MySQL reference manua...

Does R do its own swapping out to disk? I disabled Linux swapping and the system still gets stuck in Purgatory where there's little CPU activity but the disk goes like crazy. That's with R having almost the whole machine to itself and running a memory hungry compute only function. I've seen this behavior with other version numbers but I'm running R 2.0.0 under Fedora Core 3.

Hi all, I'm trying to read a 1220 * 20000 table in R but I'm having lot of problems. Basically what it happens is that R.bin starts eating all my memory until it gets about 90%. At that point it locks itself in a uninterruptible sleep status (at least that's what top says) where it just sits there barely using the cpu at all but keeping its tons of memory. I've tried with