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

Importing CSV

User, date Message
Written by ollyno1uk
7 years ago
Category: Import/Export
10 posts since Fri, 30 Nov 07
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
Written by isegrim
6 years ago
1 posts since Sat, 03 May 08
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.
Written by ansgar
6 years ago
5045 posts since Fri, 07 Apr 06
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'

Written by ansgar
6 years ago
5045 posts since Fri, 07 Apr 06
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.