mysql> LOAD DATA INFILE '/home/thufir/abc.txt' INTO TABLE delta.abc;
ERROR 13 (HY000): Can't get stat of '/home/thufir/abc.txt' (Errcode: 13)
'13' means permission denied.
That is - mysql (which is running as user 'mysql' most likely), can't
read the /path/to/abc.txt file.
Place the file i
You need a LOCAL in your LOAD statement.
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STAR
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$ cat abc.txt -n
1 "A1","B1","C1"
2 "A2","B2","C2"
3 "A3","B3","C3"
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21 to server version: 5.0
