0

I'm trying to execute this command

LOAD DATA LOCAL INFILE '/tmp/ICD9/CMS32_DESC_SHORT_DX.txt' INTO TABLE icd9_dx_code FIELDS TERMINATED BY '' (@var) SET revision = 0, dx_code = trim(Substring(@var, 1, 5)),short_desc = trim(Substring(@var, 7, 60))

but phpmyadmin shows me that error enter image description here

Actually the error means that "The command isn't permitted in this Version of MariaDB.

I've read on internet and this is because the command has too many security vulnerabilities.

Somebody knows the correct way to load data local infile?

or a command with similar result?

Hope you'll have a great day, thanks!

jarlh
  • 42,561
  • 8
  • 45
  • 63
Mizar Contasti
  • 26
  • 6
  • Does this answer your question? [Error 1148 MySQL The used command is not allowed with this MySQL version](https://stackoverflow.com/questions/12819098/error-1148-mysql-the-used-command-is-not-allowed-with-this-mysql-version) – Paul T. Mar 13 '20 at 02:48
  • What is the value of `SHOW VARIABLES LIKE 'local_infile';`? – Rick James Mar 25 '20 at 23:58

0 Answers0