How to import comma separated values from a file into mysql

Asked Aug 30 '14 at 12:39

Active Aug 30 '14 at 12:53

Viewed 144 times

I want to import data from a file into the mysql through command line only. I am using the following command but getting the following error.

Mysql>load data infile '/root/data.txt' into table test.emp fields terminated by ',' lines terminated by '\n'; ERROR 13 (HY000): Can't get stat of '/root/data.txt' (Errcode: 13)

Table structure is:

Emp_ID int

Emp_name varchar

Emp_city varchar

Content of data.txt

1,abc,London

2,def,Alberta

3,hjk,Toronto

Could somebody will help me on this how to do this via command line or any other way out?

edited Aug 30 '14 at 12:53

asked Aug 30 '14 at 12:39

gurpreet

check access permission of '/root/data.txt' – Biswajit Maji Aug 30 '14 at 12:43
777 is the permission – gurpreet Aug 30 '14 at 12:51
Do you have a phpmyadmin available? If so, it will provide you with a GUI for importing the file. – fuesika Aug 30 '14 at 12:55
no, no access to phpmyadmin.. – gurpreet Aug 30 '14 at 13:00
1

Here is a related question: http://stackoverflow.com/questions/4215231/load-data-infile-error-code-13. – Gordon Linoff Aug 30 '14 at 13:03
@GordonLinoff....i am using CentOS 6 and there is no such Apparmor and no such file /etc/apparmor.d/usr.sbin.mysqld – gurpreet Aug 30 '14 at 13:31

How to import comma separated values from a file into mysql

0 Answers0