Often, one uses /tmp or set up an appropriately premoissioned folder under /var
On Mon, Jun 23, 2014 at 10:52 AM, 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 > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
