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

mysql load-data-infile
Sameek Mishra picture Sameek Mishra · Nov 1, 2011 · Viewed 21.8k times · Source

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

Konerak picture Konerak · Nov 1, 2011

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

Related questions

How do I import CSV file into a MySQL table?

I have an unnormalized events-diary CSV from a client that I'm trying to load into a MySQL table so that I can refactor into a sane format. I created a table called 'CSVImport' that has one field for every column …

Read More
MYSQL import data from csv using LOAD DATA INFILE

I am importing some data of 20000 rows from a CSV file into Mysql. Columns in the CSV are in a different order than MySQL table's columns. How to automatically assign columns corresponding to Mysql table columns? When I execute LOAD …

Read More
Import CSV to mysql table

What is the best/fastest way to upload a csv file into a mysql table? I would like for the first row of data be used as the column names. Found this: How to import CSV file to MySQL table …

Read More