At 1:05 AM -0500 6/9/01, Marshall Bohlin wrote:
>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:
>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.
The file should be in the same directory where you're running mysql.
Otherwise, you'll need to specify the pathname to the file. For
example, if it's in the /tmp directory, your statement would be:
mysql> load data local infile "/tmp/pet.txt" into table pet;
>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.
Paul DuBois, paul@stripped