distal-attribute
distal-attribute
distal-attribute
distal-attribute

Importing CSV

ollyno1uk posted 7 years ago in Import/Export
Hi

I cannot import a CSV file - the error I get is "the used command is not allowed with this mysql version"

Is this something I can resolve? i see it has been brought up previously but not for a while so the info may not be valid.

Thanks
isegrim posted 7 years ago
Hallo,

bei mir der gleiche Fehler:

SQL-Error: The used command is not allowed with this MySQL-Version.


Verbindung funktioniert einwandfrei,
MySQL-Version 4.1.13

was kann ich tun.
ansgar posted 7 years ago
Normally a flag is set at the time being connected that allows usage of that command. You can try to set this flag manually before importing your CSV file:

SET @@global.local_infile = 'On'

ansgar posted 7 years ago
If that's not working your administrator likely has explicitely deactivated this option on the server for security reasons.

Please login to leave a reply, or register at first.