Load Data Local Infile

[Chafikb]

I'm trying to import some data from a .txt file. my database is set up and ready for use but when I type in the command
LOAD DATA LOCAL INFILE 'C:/mysql/sampdb/member.txt' INTO TABLE sampdb.member
to import the data to my table, I get the following error.
The used command is not allowed with this MySQL version.
the MySQL version I'm using is 4.0.12-nt

Any Help is appericated. Thanks!

[tsinka]

Hi,

check if there is a value in my.cnf looking like

set-variable local-infile 0

Set it to 1. You might additionally try to start mysql with --local-infile=1.

[Chafikb]

I got this resolved by removing the "LOCAL" from the command.
Thanks very much for your help.😃