[SOLVED] First time error (new server)

[chadrt]

I have received this error from a shell script that I have been using on a many servers now but this time it is different because I dont know what this error could be all about.  I went out and purchased a Virtual Private Server space giving me root access and all that fancy stuff I only 1% about to begin with.  Well when I went to run my script it shot this error out at me:

 

mysql -u myusername -pmypassword uls < ./load-am.sql
ERROR 1148 (42000) at line 1: The used command is not allowed with this MySQL version

 

and here are the contents of that load-am.sql file that I have.

 

load data local infile './AM.dat' into table AM fields terminated by '|';

 

Dont laugh because this took me a solid month to figure out the first time I did this.  This database is supposed to be filled with over a million records and now it wont update because of this little problem of mine.  This is part of my very first database project ever and it was running on three different professional servers over the past two months.  But now some funky error message grrr...  Any help would be great.  Thank you!

[Wildbug]

And what version is it?

[chadrt]

mysql  Ver 14.7 Distrib 4.1.10a, for suse-linux (i686)

 

I was able to make it work by replacing this:

 

mysql -u myusername -pmypassword uls < ./load-am.sql

 

with this here:

 

mysql -u myusername -pmypassword --local-infile uls < ./load-am.sql

 

Although why this worked I guess you all would be able to tell me more easilly.