MySQL-Front File Upload....

[silveybk]

LOAD DATA LOCAL INFILE 'C:/import.txt' INTO TABLE XX.Test FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n\r' (ItemNo,Name,Make,Model,Year,Type,Price,Shipping,C ompany,Category,ModelNum)
Error: 1148 - The used command is not allowed with this MySQL version

If I try to use the same statement and omit the 'LOCAL' keyword I get:

Error: 1045 - Access denied for user: 'myusername@XXX.XXX.XX.XXX' (Using password: YES)

What am I doing wrong? The file I'm uploading is comma seperated values and line terminated with '\n\r'..... Any help would be appreciated. Thanks.

[HalfaBee]

Try uploading the file to the server and
LOAD DATA INFILE '/www/u/user/import.txt' INTO TABLE XX.Test FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n\r' (ItemNo,Name,Make,Model,Year,Type,Price,Shipping,C
ompany,Category,ModelNum)

I haven't tried it but give it a go.

HalfaBee