I've been trying to import text files into MySQL, but I can't get it to
work. I'm new to MySQL and am still getting familiar with it, so
perhaps I'm missing something. I'm using the LOAD DATA LOCAL command
but I keep getting error 1148 "The used command is not allowed with this
MySQL version." Now from reading the information in the docs section
(http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html) it appears that LOAD
DATA LOCAL is sometimes disabled for security reasons, and that there
are two ways around this. I've tried both ways but it doesn't seem to
work. I tried using the command --enable-local-infile but apparently
that's only compatible with version 3.23.48 and before, and we have
3.23.49. Is there something else I should do? Can anyone help me
please? Thanks so much!
Christy Roberts
Technical Project Lead
iMIRADOR.com Inc.
St. John's, Newfoundland
Tel: 709.737.4485