Is there is any way to run
LOAD DATA INFILE
LOAD DATA INFILE 'USER%40WEBSITE.COM:PASSWORD@ftp.WEBSITE.COM/FILE.csv';
REPLACE INTO TABLE mytable FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' IGNORE 1 LINES
No, MySQL file-related functions can only access files on the database server or the client, but not other machines (unless you've set up a network file system mount, to make the remote machine appear to be local).