JuanJuan77, no sé si lo he entendido bien pero, ¿quieres subir el fichero por FTP y cargarlo con LOAD y no sabes la sintaxis para ello?
Código:
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[PARTITION (partition_name,...)]
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number {LINES | ROWS}]
[(col_name_or_user_var,...)]
[SET col_name = expr,...]
MySQL :: MySQL 5.7 Reference Manual :: 14.2.6 LOAD DATA INFILE Syntax