"LOAD DATA LOCAL INFILE" fails after upgrade - VisualCron - Forum

Community forum

ep90
  •  ep90
  • Paid support Topic Starter
2020-07-21T15:58:19Z
Since upgrading to from 9.1.5 to 9.3 all mysql queries that use "LOAD DATA LOCAL INFILE" are failing with error:

Exception in Task: MySql.Data.MySqlClient.MySqlException (0x80004005): The used command is not allowed with this MariaDB version


I've checked the server and local_infile is still set to ON

mariadb> SHOW VARIABLES LIKE 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile  | ON    |
+---------------+-------+
1 row in set (0.06 sec)


Is was working perfectly in the previous version of Visual Cron. Is there an extra setting maybe on the connection that needs to be configured to allow local file imports?

Many thanks


ep90
  •  ep90
  • Paid support Topic Starter
2020-07-23T11:39:35Z
If anyone else has this issue, I fixed it by adding AllowLoadLocalInfile=true as a parameter in the connection string
Scroll to Top