Load DATA INFILE 'file.txt' not found (Errcode:2)

[Martha Van Orshoven]

I'm using a Mac and version 5.1 of MySQL.

I’m attempting to load the initial database tables with txt files.

The first one went fine and then I decided to modify it; The modified file is not being found by mysql even though an “ ls –l” at the command line shows the file there.

The original modified file, I modified and then copied to the correct path using
Sudo cp /Users/mvanorshoven/Downloads/grasstablemin.txt /usr/local/mysql/bin

The permissions on the new file read
-rw-r-r--@ 1 root wheel

My next experiment was to do an exact copy of the file that mysql was recognizing;
cp grasstable.txt grasstable2.txt

The permissions on new file read exactly the same as the old and the file size is exactly the same. However, even though I’m able to load the data from grasstable.txt into my mysql table, I can’t load grasstable2.txt

Any ideas?



Edited 1 time(s). Last edit at 06/16/2009 12:12PM by Martha Van Orshoven.