List:General Discussion« Previous MessageNext Message »
From:Scott Helms Date:June 23 2014 2:59pm
Subject:Re: error 29, file not found (errcode: 13)
View as plain text  
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