LOAD DATA INFILE on remote machine

Question

How would I do the following command, with a local file, on a remote database (different machine) ?

$MYSQL_PATH/mysql -u root -h remote.net files -e "
    LOAD DATA INFILE '$1'
    INTO TABLE $TABLE_NAME
    FIELDS TERMINATED BY ','
      (size, @d2, @d3, @d4, @d5, path)

The problem seems to be that the INFILE at /tmp/infile.txt is not being recognized remotely. What would be the correct way to accomplish the above?

score 38 · Accepted Answer · answered Mar 22 '13 at 20:33

38

LOAD DATA INFILE loads a file on machine the MySQL server is running on.

Use LOAD DATA LOCAL INFILE to load a file located on your client machine.

answered Mar 22 '13 at 20:33

nos

223,662
58
417
506

David542 · Answer 2 · 2013-03-22T22:43:16.580

10

Don't forget to include --local-infile=1 when doing this:

$MYSQL_PATH/mysql -u root -h remote.net files --local-infile=1 -e "
    LOAD DATA LOCAL INFILE...

edited Mar 22 '13 at 22:43

answered Mar 22 '13 at 20:51

David542

104,438
178
489
842

LOAD DATA INFILE on remote machine

2 Answers2

Linked