title: LOAD DATA INFILE on remote machine
body: <p>How would I do the following command, with a local file, on a remote database (different machine) ?</p>
  
  <pre><code>$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)
  </code></pre>
  
  <p>The problem seems to be that the INFILE at <code>/tmp/infile.txt</code> is not being recognized remotely. What would be the correct way to accomplish the above?</p>