Load DATA INFILE 'file.txt' not found (Errcode:2)
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.
Subject
Views
Written By
Posted
Load DATA INFILE 'file.txt' not found (Errcode:2)
8049
June 16, 2009 11:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.