title: Need Guidance with 'LOAD DATA INFILE'
body: <p>I have created a file called '/root/jyoti/test.txt' with below contents:</p>
  
  <pre><code>tail /root/jyoti/test.txt
  20,'Daily','Complete'
  21,'Daily','Complete'
  22,'Daily','in-progress'
  </code></pre>
  
  <p>Then tried to following query to load the data in a mysql table say 'test'</p>
  
  <pre><code>mysql&gt; select * from test;
  +----+-----------+------------+
  | id | testname  | testtype   |
  +----+-----------+------------+
  |  2 | Daily     | Complete   |
  
  
  mysql&gt; load data infile '/root/jyoti/test.txt' into table accounts fields terminated by ',' (id,testname,testtype);
  ERROR 13 (HY000): Can't get stat of '/root/jyoti/test.txt' (Errcode: 13)
  </code></pre>
  
  <p>From another post I found someone recommended to use 'load data local infile' instead of 'load data infile', but this too failed with error.</p>
  
  <pre><code>mysql&gt; load data local infile '/root/jyoti/test.txt' into table accounts fields terminated by ',' (id,testname,testtype);
  ERROR 1148 (42000): The used command is not allowed with this MySQL version
  </code></pre>
  
  <p>I am using following MySql version:-</p>
  
  <pre><code>mysql -V
  mysql  Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.2
  cat /etc/issue
  Debian GNU/Linux 7 \n \l
  </code></pre>
  
  <p>The file have below permission:</p>
  
  <pre><code>stat /root/jyoti/test.txt
    File: `/root/jyoti/test.txt'
    Size: 67              Blocks: 8          IO Block: 4096   regular file
  Device: de00b6d1h/3724588753d   Inode: 554931      Links: 1
  Access: (0644/-rw-r--r--)  Uid: (    0/    root)   Gid: (    0/    root)
  Access: 2014-06-16 12:33:34.122226597 +0530
  Modify: 2014-06-16 12:33:34.122226597 +0530
  Change: 2014-06-16 12:33:34.488226595 +0530
   Birth: -
  </code></pre>