You have to use Load Data Local. See this section of the manual:
http://www.mysql.com/doc/en/LOAD_DATA.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi everyone,
I am trying to get the following statement to work from any directory
besides [ /usr/local/mysql/data/testdb ] :
LOAD DATA INFILE 'data.txt' INTO TABLE sometbl TERMINATED BY '|' LINES
TERMINATED BY '\n';
I see ERROR 1105: File './testdb/data.txt' not found (Errcode: 2)
I also star