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

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

Up vote 2 down vote favorite share g+ share fb share tw.

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?

Mysql load-data-infile link|improve this question edited Nov 1 '11 at 10:22Konerak13.8k21341 asked Nov 1 '11 at 10:17sam654321 95% accept rate.

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.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.