Hey everyone
I am using Mysql Connector and DB Loader nodes to load data to local database, I am new in database field and this my first time I am using knime for such a task
in DB loader node, when I try to run the node it gives the error: Execute failed: Loading local data is disabled; this must be enabled on both the client and server sides.
Can you please advise what should I do in this case to overcome this problem ?
Best Regards
Hi @Mutaz,
The DB Loader uses the database’s batch loading functionality. It first creates a CSV file and then sends that to the DB, which loads it into a table. On the client side, which is KNIME, the functionality is enabled just by using the DB Loader, but I assume that you need to enable batch loading on the database side. I am not familiar enough with MySQL to tell you how to do that, though.
Kind regards,
Alexander
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.