Open hwooo opened 5 years ago
Could you try to start mycli using the argument --local-infile=true
and retry the LOAD DATA command?
The official mysql client requires this as well but it might by preconfigured for you somewhere. You can also add local_infile = true to my.cnf and mycli should use it as well.
Can I add local_infile = true
to .myclirc file?
Hmm, no, but you can add it to ~/.my.cnf
and if I'm not mistaking you should use local-infile = 1
or loose-local-infile = 1
-> 1148, 'The used command is not allowed with this MariaDB version'
-> Query OK
Same table, same query is used but importing csv through mycli is impossible because of syntax issue.