The used command is not allowed with this MySQL version within R Studio

Asked Oct 22 '15 at 11:02

Active Oct 22 '15 at 11:19

Viewed 416 times

I have a MYSQL (which I'm very new to) database hosted on azure, which i'm trying to write data to from RStudio using the RMySQL package.

I am receiving the following message

> dbWriteTable(searchdb,"searchrecords",data, append = TRUE)
Error in .local(conn, statement, ...) : 
 could not run statement: The used command is not allowed with this MySQL version

Can anybody provide a suggestion as to why this may be?

edited Oct 22 '15 at 11:19

David Arenburg

91,361
17
137
196

asked Oct 22 '15 at 11:02

Jennifer Neary

Thanks for your answer but being completely new to MySQL, I wouldn't have the first clue of how to follow these instructions. – Jennifer Neary Oct 22 '15 at 11:12
i had the same problem, but i cant remember how i solved it. will research and post when i find it – user670186 Jan 19 '16 at 19:21
answer provided here: http://stackoverflow.com/questions/10762239/mysql-enable-load-data-local-infile – user670186 Jan 19 '16 at 19:24

The used command is not allowed with this MySQL version within R Studio

0 Answers0