0
''' dbWriteTable(mydb, "Albums1", tracks_list) '''

Error in .local(conn, statement, ...) : could not run statement: Loading local data is disabled; this must be enabled on both the client and server sides

This is the error I get when I try to make a table in the database, It makes the table but does not transfer the data.

bigdog0789
  • 1
  • 1
  • https://stackoverflow.com/questions/59993844/error-loading-local-data-is-disabled-this-must-be-enabled-on-both-the-client – DPH Mar 14 '21 at 20:13
  • I dont understand – bigdog0789 Mar 15 '21 at 00:21
  • are you sure, that your data base user is allowed to write data to the DB? (the link I posted talks about the main issues related to your problem) – DPH Mar 15 '21 at 00:25
  • How would I be able to check that? – bigdog0789 Mar 15 '21 at 00:33
  • did you set up the data base or did someone give you the access data you are using in R to dump the data? – DPH Mar 15 '21 at 00:34
  • I set up the database myself – bigdog0789 Mar 15 '21 at 00:36
  • ok - then you should try to create a new user for the DB with full rights including writing to the DB (read into the mysql doc) and use this for the conection from R ... I do not know your setup and can not replecate it but the solution should be within the link (or further links from there) – DPH Mar 15 '21 at 00:40
  • Do you have discord by any chance and could help me with this? – bigdog0789 Mar 15 '21 at 00:41
  • unfortunately I wont be of much help configuring DB and user - I know how to do the basics in postgres... you will have to wait on someone else or just dig arround the web: https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql – DPH Mar 15 '21 at 00:45

0 Answers0