Importing CSV
| User, date | Message |
|---|---|
|
Written by ollyno1uk
5 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
5 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
5 years ago 3950 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
5 years ago 3950 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. |