David Logan wrote:
Karl Krelove wrote:
I'm trying to import a large amount of data from an Access database
containing information about 9,000+ students in a school system. I've
created a table 'student_list' to hold the data and issued the
following command:
LOAD DATA INFILE 'home/karl/Student_List.csv' into table student_list
FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n';
In response I get: ERROR 13 (HY000): Can't get stat of
'/var/lib/mysql/home/karl/Student_List.csv' (Errcode: 2)
I've looked up the error on the MySQL website and found the error
listed as Error 1013 in the listing of server errors for MySQL 4.1,
but I can't find an explanation.
1st question - the obvious one - does anyone know what is triggering
the error?
2nd question - why does MySQL only list the errors? I could already
read what it said in the CLI client. Is there a place on the web site
that actually explains what specific errors mean?
Thanks in advance for any input.
Karl Krelove
Hi Karl,
Do you have your home directories under the mysql path? When you are
doing a LOAD DATA INFILE the following rules (from the manual) apply
to the pathname
large snip
I suspect, based on these rules, it will be looking for the file
relative to /var/lib/mysql as it states in the error message. Further
info is available at
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
Regards
My first reaction as I read your response was But I had just run a LOAD
INFILE command on another table from the same database - same directory,
same command, nothing different except the filename and the table name -
with no path problem. Then I looked a little closer at the LOAD INFILE
I pasted into this message. What a difference a single slash can make!
When I re-ran the command in MySQL using the same path but with a slash
at the _beginning_ - '/home/karl/Student_List.csv' - it worked and the
data was imported in about a hundredth of a second! Thanks for pointing
me toward a path problem. Does Can't get stat translate to File not
found? And as for my other general question, is there a resource online
(or even in a bound manual) that actually explains MySQL error messages?
There is that huge listing on the MySQL website that _lists_ a gazillion
errors and their numeric codes, but no links to explanations.
Thanks again.
Karl