Well that didn't work here is the telnet response:
mysql> LOAD DATA LOCAL INFILE 'pet.txt' INTO TABLE pet
-> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
-> LINES TERMINATED BY '\n';
ERROR 1064: parse error near 'LOCAL INFILE 'pet.txt' INTO TABLE pet
FIELDS TERMINATED BY ',' ENCLOSED BY '"' ' at line 1
It appears that LOCAL is causing the parse error but I can't see what I am
doing wrong with it. Any ideas?
At 06:00 PM 05/22/1999 -0400, Christopher R. Jones wrote:
>Use LOAD DATA LOCAL INFILE ......
>if the text file is not in the same directory as the database tables
>>When I try to use LOAD DATA INFILE 'RWTest.txt' INTO TABLE testaa
>> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
>> LINES TERMINATED BY '\n';
>>I get an error that ./test/RWTest.txt does not exist.
>>I do not have root access to the server and infact I am unable to even
>>telnet directly to the mysql server( I have been set up as Local Host
>>through a UNIX socket). I can only load the files into my virtural server (
>>www.sbenterprise.com/hold ) directories. How can I use this command?
>>The other concern is when trying to export the data it saves the file to
>>the mysql server and I can't get it to save it to my directory.
>>CIHost has not been helpful with this problem and I was hoping someone who
>>may have a similar setup would be able to help me out.