Hello,
According to MySQL documentation the
LOCAL
keyword affects expected location of the file and error handling.
LOCAL
works only if your server and your client both have been configured to permit it. For example, if mysqld was started with --local-infile=0,
LOCAL
does not work. In such a case you will have to transfer the file to the server on which MySQL is running, if it's not running on the same machine on which your ASP.NET web site is located. Also you need to ensure that the MySQL service has read access to the folder containing the csv file and you also specify the full path of the file in SQL. Reference to MySQL documentation can be found here[
]
Regards,