how to upload a file on a mysql server if access to temp folder is not present I have a CSV file that i want to enter into a table in my database which is present on a remote server. But presently I don't have access to temp folder so I cannot copy my file on that folder. Is there a way I can upload file from any random folder onto the database?

This is my command in sql server:

load data local  infile 'C:/Users/trainee_aiyer/Downloads/cash_ord.csv' into table cm_ord fields terminated by ',' enclosed by '"' lines terminated by '\n';


and my file path is this:

C:\Users\trainee_aiyer\Downloads\cash_ord.csv


I switched '\' to '/' as the prior was causing syntax errors. but I get an error saying 

ERROR 2 (HY000): File 'C:/Users/trainee_aiyer/cash_ord.csv' not found (Errcode: 2 "No such file or directory")
From MySQL documentation, it seems it is not possible, since it is operating systems temporary directory and not it is not configured in MySQL. 


  When using LOCAL with LOAD DATA, a copy of the file is created in the
  server's temporary directory. This is not the directory determined by
  the value of tmpdir or slave_load_tmpdir, but rather the operating
  system's temporary directory, and is not configurable in the MySQL
  Server. (Typically the system temporary directory is /tmp on Linux
  systems and C:\WINDOWS\TEMP on Windows.) Lack of sufficient space for
  the copy in this directory can cause the LOAD DATA LOCAL statement to
  fail.


Alternative, you may try with mysqlimport with local parameter, but make sure, you have access to that directory, else you may encounter an error. I hope this answer will help you. Thank you.