Both the client and the server must have that option enabled. You
must also have the right setup in your grant tables to load files.
Try loading it locally (with out the LOCAL flag) and see if that helps.
Tristan Trio wrote:
> Am new to mySQL. I had installed mySQL version 3.23.49 on my pc
> running on windows 98. My problem is when I tried to populate a
> database using the command:
> load data local infile "uprhs.txt" into table uprhs;
> i get an error message "ERROR 1148: The used command is not allowed
> with this MySQL version"
> Is that command not availbale in version 3.23.49 if yes what is the
> alternate command for it.
> Would appreciate any help you can give me.