Load Data Local Infile with Connector/C++
I'm trying to execute a LOAD DATA LOCAL INFILE ... statement in an SQL statement using Connector/C++ (with MySQL 8 on Ubuntu with G++). I get an error: ERROR: CDK Error: The used command is not allowed with this MySQL version. I've specified loose-local-infile=1 and local-infile=1 for both client and server in the cnf files. My LOAD DATA LOCAL INFILE ... statement works fine in the mysql client, so I don't think there's anything wrong with the statement itself.
In the older C connector version, you can include a call to
mysql_options (&mysql, MYSQL_OPT_LOCAL_INFILE, 0)
which makes it possible to use the statement. Is there any way to set client/connection options in the Connector/C++? Should I roll back to using the C connector?
Any suggestions would be much appreciated.
Subject
Views
Written By
Posted
Load Data Local Infile with Connector/C++
1639
June 28, 2018 03:26PM
687
August 15, 2018 08:05AM
739
August 16, 2018 05:25AM
732
August 16, 2018 02:04PM
862
August 27, 2018 05:01AM
687
August 27, 2018 07:04AM
765
August 27, 2018 07:47PM
681
August 27, 2018 09:41PM
660
September 19, 2018 09:09AM
792
August 21, 2018 04:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.