LOAD DATA LOCAL INFILE and ERROR 1148

[123jon]

When I execute the follwing command:
LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;

I am getting the following error:
'ERROR 1148: THE USED COMMAND IS NOT ALLOWED WITH THIS MySQL VERSION'

I am using MySQL version 3.23.54-max-debug.

I start MySQL with MYSQLD --LOCAL-INFILE=1
I thought that would solve the problem.

Anyway, someone please tell me how to load a text file to a table.

Thank you.

 

[KarveR]

Try replacing the " with ' quotes.

I had this problem before and it was something really daft like that. - I'm still running the same version and INFILE works just fine now so I know it can't have been much. ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[sleipnir214]

123jon:

The LOCAL keyword is only used if the file containing the data does not reside on the server running MySQL, but rather on the client machine. Is this the case? Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[KarveR]

Nah it was far more obvious .. mysql version 3.23.49 - local infile disabled by default unless specifically compiled in at build time.

To get round it start a mysql session from a command prompt using mysql --local-infile=1

more details can be found by searching mysql.com for Error 1148.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[123jon]

Thank you all 'MYSQL -u username --LOCAL-INFILE=1' worked.