Hi Everyone, While writing the data in MYSQL through R, I am unable to do it as it is showing the below error.
could not run statement: Loading local data is disabled; this must be enabled on both the client and server sides
However, If I am using tableau prep to write the data in MYSQL with same credentials I am able to do it. I am also able to fetch the data through query for ET purpose.
Below is the code that I am using to write in DB.
dbWriteTable(mydb, name = "testtable", value = dataframe, row.names = FALSE, append=TRUE)