1148 - The used command is not allowed with this MySQL version

[ethanone]

I'm trying to import a text file and I get this error "1148 - The used command is not allowed with this MySQL version"

I'm using mysql 3.23.53-max-nt/mySQL-front on Win XP pro. The help file at mysql.com wasn't helpful.

Supposedly there is an option to enable the load local file, but I can't find where to set it or how to do it.

 

[AHinMaine]

from the mysql prompt:

source /path/filename

--
Andy

http://www.nachoz.com

 

[hvass]

My guess is that you may be having a problem with mySQL-front rather than mysql the server. I am a big fan of mySQL-front but use the menu items as an aide memoir only - if I have problems I resort to straight mysql commands in the editor ...

load data local infile 'c:\\mydirectory\\myfile.txt' into mynewmysqlfile lines terminated by '\r\n' etc....

note you have to double escape file names to get them into windows speak or sometimes just using forward slash '/mydirectory/myfile.txt'