Intekhab Khan Intekhab Khan - 1 month ago 15
MySQL Question

Can load data in file take ftp file location

Is there is any way to run

LOAD DATA INFILE


command, when file exists in FTP location? For example something like this:

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

Answer

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).