Importing CSV

10 posts
[expired user #3257]'s profile image [expired user #3257] posted 16 years ago in Import/Export Permalink
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
1 posts
[expired user #3464]'s profile image [expired user #3464] posted 16 years ago Permalink
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.
10151 posts
ansgar's profile image ansgar posted 16 years ago Permalink
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'
10151 posts
ansgar's profile image ansgar posted 16 years ago Permalink
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.