List:General Discussion« Previous MessageNext Message »
From:Carsten Pedersen Date:June 23 2014 5:24pm
Subject:Re: error 29, file not found (errcode: 13)
View as plain text  
Or use the LOCAL diective to have the client send the csv file contents 
to the server.

/ Carsten


On 23-06-2014 16:59, Scott Helms wrote:
> I generally drop them into /tmp for easy access and cleanup after the data
> load, but you can put them any place that the mysql daemon process has
> access to read.
>
>
> Scott Helms
> Vice President of Technology
> ZCorum
> (678) 507-5000
> --------------------------------
> http://twitter.com/kscotthelms
> --------------------------------
>
>
> On Mon, Jun 23, 2014 at 10:52 AM, thufir <hawat.thufir@stripped> wrote:
>
>> Apparently this error is because MySQL can't read my home directory?  Fair
>> enough, but I don't quite follow.  Where would be a good location for the
>> CSV file, then?
>>
>>     thufir@dur:~$
>>     thufir@dur:~$ mysql -u root -p
>>     Enter password:
>>     Welcome to the MySQL monitor.  Commands end with ; or \g.
>>     Your MySQL connection id is 62
>>     Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)
>>     Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights
>>     reserved.
>>     Oracle is a registered trademark of Oracle Corporation and/or its
>>     affiliates. Other names may be trademarks of their respective
>>     owners.
>>     Type 'help;' or '\h' for help. Type '\c' to clear the current input
>>     statement.
>>     mysql>
>>     mysql> LOAD DATA  INFILE '/home/thufir/make_year_model.csv' INTO
>>     TABLE vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY
>>     '\n';
>>     ERROR 29 (HY000): File '/home/thufir/make_year_model.csv' not found
>>     (Errcode: 13)
>>     mysql>
>>     mysql> quit
>>     Bye
>>     thufir@dur:~$
>>     thufir@dur:~$ cat /home/thufir/make_year_model.csv
>>     make1,model1,2012,604,buy now
>>     make2,model2,2013,780,need to sell
>>     make3,model3,2001,780,cheap
>>     thufir@dur:~$
>>
>>
>>
>> thanks,
>>
>> Thufir
>>
>>
>
Thread
error 29, file not found (errcode: 13)thufir23 Jun 2014
  • Re: error 29, file not found (errcode: 13)Scott Helms23 Jun 2014
    • Re: error 29, file not found (errcode: 13)Carsten Pedersen23 Jun 2014
  • Re: error 29, file not found (errcode: 13)Michael Dykman23 Jun 2014
  • Re: error 29, file not found (errcode: 13)Divesh Kamra23 Jun 2014
  • Re: error 29, file not found (errcode: 13)thufir24 Jun 2014
    • Re: error 29, file not found (errcode: 13)Reindl Harald24 Jun 2014
  • Re: error 29, file not found (errcode: 13)thufir24 Jun 2014
  • Re: error 29, file not found (errcode: 13)thufir26 Jun 2014