Not sure what the "load data local infile" thing is, but I always
load text files from the command line like this (on Red Hat linux):
% mysql -u some_guy -p some_db < /full/path/to/file.txt
>I'm a new user, working through the tutorial provided in the MySQL
>documentation (chapter 9). I'm trying to load the data from the
>pet.txt file into the pet table using the specified command: mysql>
>load data local infile "pet.txt" into table pet;
>
>I get the following:
>ERROR:
>File 'pet.txt' not found (Errcode: 2)
>
>I assumed that the text file was in the wrong directory, and
>reviewed the section describing the load data local command. Just to
>be safe, I put copies of the text file in several locations,
>including the menagerie directory (which should be the only one
>required), the bin directory, and the mysql directory. I still get
>the error message.
>
>What might I be doing wrong?
>
>Also, is there a FAQ that might hold the answer to newbie questions like this?
>
>Thanks for the help.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
