{"comment":{"created_at":"2011-10-16T21:16:38Z","body":"+1.  The LOAD DATA LOCAL INFILE command is essential. It saves a lot of time and server resources.\r\n","updated_at":"2011-10-16T21:16:38Z","url":"https://api.github.com/repos/petehunt/PyMySQL/issues/comments/2423088","id":2423088,"user":{"gravatar_id":"da3b45bdb54369753ed1a6655f586a8f","avatar_url":"https://secure.gravatar.com/avatar/da3b45bdb54369753ed1a6655f586a8f?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/sebrenner","id":162030,"login":"sebrenner"}},"action":"created","issue":{"number":62,"created_at":"2011-07-27T20:53:40Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"Originally filed by fla.sam on 2011-04-29T08:58:02\n\nWhat steps will reproduce the problem?\n1. I try to load a local data from a csv format file into remote mysql-server\"\r\nLOAD DATA LOCAL INFILE 'a_csv_file' \r\n            INTO TABLE some_table_name\r\n            FIELDS \r\n                TERMINATED BY ','\r\n                ENCLOSED BY '\"'\r\n            LINES \r\n                TERMINATED BY '\\n'\r\n            IGNORE 1 LINES\r\n            (field1, field2)\r\n\" \r\n\r\nWhat is the expected output? What do you see instead?\n  File \"/home/sam/workspace/lqjh2/lqjh2_admin_srv/pre_data/load_pre_data.py\", line 62, in main\r\n    cursor.execute(sql)\r\n  File \"/home/sam/PY_ENV/lq2_ENV/lib/python2.7/site-packages/django/db/backends/util.py\", line 15, in execute\r\n    return self.cursor.execute(sql, params)\r\n  File \"/home/sam/PY_ENV/lq2_ENV/lib/python2.7/site-packages/django/db/backends/mysql/base.py\", line 86, in execute\r\n    return self.cursor.execute(query, args)\r\n  File \"/home/sam/PY_ENV/lq2_ENV/lib/python2.7/site-packages/pymysql/cursors.py\", line 108, in execute\r\n    self.errorhandler(self, exc, value)\r\n  File \"/home/sam/PY_ENV/lq2_ENV/lib/python2.7/site-packages/pymysql/connections.py\", line 184, in defaulterrorhandler\r\n    raise errorclass, errorvalue\r\ndjango.db.utils.DatabaseError: (1148, u'The used command is not allowed with this MySQL version')\r\n\r\nbut when i switch to \"MySQL-python\" it's everything fine.\r\n\r\nWhat version of the product are you using? On what operating system?\n0.4","comments":5,"title":"pymysql does not support  \"LOAD DATA LOCAL\" ?","updated_at":"2011-10-16T21:16:38Z","url":"https://api.github.com/repos/petehunt/PyMySQL/issues/62","id":1298860,"assignee":null,"milestone":null,"closed_at":null,"user":{"gravatar_id":"1529ee4850653ed595b6d47c6b7d6b3b","avatar_url":"https://secure.gravatar.com/avatar/1529ee4850653ed595b6d47c6b7d6b3b?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/petehunt","id":239742,"login":"petehunt"},"html_url":"https://github.com/petehunt/PyMySQL/issues/62","labels":[{"name":"Priority-Medium","url":"https://api.github.com/repos/petehunt/PyMySQL/labels/Priority-Medium","color":"ededed"},{"name":"Type-Defect","url":"https://api.github.com/repos/petehunt/PyMySQL/labels/Type-Defect","color":"ededed"}],"state":"open"},"legacy":{"issue_id":1298860,"comment_id":2423088}}