Support "LOAD DATA LOCAL INFILE" in MySql
- Dominant language
- Python
- Stars
- 1k
- Forks
- 131
- PR merge metrics
- No merged PRs in 30d
Description
I am trying to load a local csv file to a remote MySql server using odo lib, but I got the following error:
InternalError: (pymysql.err.InternalError) (1290, u'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement') [SQL: u'LOAD DATA INFILE %(path)s\n INTO TABLE `GlobalObjects`\n CHARACTER SET %(encoding)s\n FIELDS\n TERMINATED BY %(delimiter)s\n ENCLOSED BY %(quotechar)s\n ESCAPED BY %(escapechar)s\n LINES TERMINATED BY %(lineterminator)s\n IGNORE %(skiprows)s LINES\n '] [parameters: {'lineterminator': '\n', 'encoding': 'utf8', 'skiprows': 1, 'delimiter': ',', 'escapechar': '\\', 'quotechar': u'"', 'path': '/tmp/my_table.csv'}]
It does not appear it use "LOCAL DATA LOCAL INFILE" statement, which is wrong for loading local file to remote server.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.