Sol :- Change file owner to mysql.mysql OR Change folder and file mode to 777
DK Sent from Phone > On 23-Jun-2014, at 8:22 pm, thufir <hawat.thu...@gmail.com> 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql