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.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 > >
