Uploading to database using SQL

I am getting an access denied error when I am writing to the database

I am using this line

LOAD DATA INFILE 'upload.txt' REPLACE INTO TABLE Test FIELDS TERMINATED BY ','

I have made sure I allowed remote SQL, and I made sure to give the user all privileges.

What could be causing this error?

Practically a Master Poster

661 posts since Oct 2010

Reputation Points: 45

Solved Threads: 19

Have a look at the LOCAL option in the upload statement and make sure that upload.txt is readable by the mysql daemon (not by the mysql user).
See http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Nearly a Posting Virtuoso

1,233 posts since Oct 2010

Reputation Points: 300

Solved Threads: 254

This question has already been solved

You