When I use
LOAD DATA INFILE 'http://www.thesite.com/dir/dir2/file.txt' INTO TABLE request_import FIELDS TERMINATED BY '\t' ESCAPED BY '\' LINES TERMINATED BY '\r' IGNORE 1 LINES (time, CHW_In, CHW_Out, CDW_In, CDW_Out, Amps, Evap_Tmp, Cond_Tmp, CHW_Delta, CDW_Delta, Evap_Aprch, Cond_Aprch, KW, Inst_Tons, AmpssTon, KWsTon)
i get the error
Access denied for user: '$dbname@localhost' (Using password: YES)
Why doesn't this work? I tried taking away the whole .com part and just starigin with dir/dir2/file.txt
