1

Gone through the below link also but i am unable to import CSV file in mysql. Even i had tried by using > LOAD DATA LOCAL INFILE but same error persisting. Please help me in this. queries i tried had appended below

MySQL import csv only gets half the lines

mysql> LOAD DATA INFILE 'home/karthick.g.s/Desktop/karthick.csv' -> INTO TABLE test_1 -> FIELDS TERMINATED BY ',' -> ENCLOSED BY '^' -> LINES TERMINATED BY '\r\n'; ERROR 13 (HY000): Can't get stat of '/var/lib/mysql/home/karthick.g.s/Desktop/karthick.csv' (Errcode: 2) mysql> LOAD DATA LOCAL INFILE 'home/karthick.g.s/Desktop/karthick.csv' -> INTO TABLE test_1 -> FIELDS TERMINATED BY ',' -> ENCLOSED BY '^' -> LINES TERMINATED BY '\r\n'; ERROR 1148 (42000): The used command is not allowed with this MySQL version

I am using the version 5.5.37-0ubuntu0.12.04.1

Improve this question
2
  • dba.stackexchange.com/questions/55960/… Commented Jul 19, 2014 at 8:04
  • @stacylaray attached link has mentioned to use LOAD DATA LOCAL INFILE i had tried that also please check my second query... Commented Jul 19, 2014 at 8:48

1 Answer 1

Reset to default
2

From the manual here, you could try experimenting with your my.cnf settings - I know that I had this problem in the past and I eventually got around this by using [client] setting.

# added from http://dev.mysql.com/doc/refman/5.6/en/load-data-local.html # to allow for abrowse to load data! loose-local-infile = 1 local-infile = 1

Now, it was either local-infile or loose-local-infile which worked eventually. I believe that loose-local-infile is the more permissive setting, so you could try that first - and if you've no security concerns on your server, you could leave it at that.

Improve this answer
1
  • This issue goes way back to 2002 : lists.mysql.com/mysql/115782. Your answer fits here. Using [mysql] group header would probably be more applicable if other client tools do no recognize local-infile. +1 !!! Commented Jul 20, 2014 at 1:43

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.