error when trying to load data into a table

[wailerwailer]

I am trying to work with a mysql tutorial and everytime I try to load the *.txt file I get the following.

mysql> LOAD DATA LOCAL INFILE "C:\menagerie\pet.txt" INTO TABLE pet;
ERROR 1148: The used command is not allowed with this MySQL version


Does anybody know how to fix this?

 

[sleipnir214]

Drop the keyword "LOCAL" from your query.

The "LOCAL" keyword implies "local to the client from which you are connecting", not "local to the database server". It's a function where a datafile can be bulk loaded without having to write it to the server first.

Want the best answers? Ask the best questions:

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

TANSTAAFL!