How to use LOAD DATA INFILE statement when file is another location?

Question

I want to use LOAD DATA INFILE statement to import data in my table.

If the file is available on the same system, it works nicely and imports successfully, but when the file is located on another system, it cannot locate the path.

Can anyone explain how to use the LOAD DATA INFILE statement to import data into MySQL table from another system, or remotely?

Answer 1

When you do a LOAD DATA INFILE, the file must be on the system that is running the MySQL database, in the data path.

If the file is on your system, add the LOCAL keyword. The file will then be sent to the server, stored in a temporary directory, and run from there. This only works if the necessary permissons are set.

LOAD DATA LOCAL INFILE '/path/to/your/local/file' INTO TABLE yourtable