I'm trying to insert data from a .txt file (in csv format) to one of my database tables using the LOAD DATA INFILE command as follows:
LOAD DATA INFILE 'http://transit.adigitalcity.com/data_uploads/stoptimes.txt' INTO TABLE ttc_stoptimes FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n';
When I do so, it gives me an error:
"ERROR 1045 (28000): Access denied for user 'userxxxx'@'%' (using password: YES)"
I read in this thread that you can't use an HTTP link for this command, but I can't figure out what to do instead. Here's a screenshot of where I am now:
Help would be greatly appreciated.