use the mysqlimport tool
>From: Sean <sean@stripped>
>To: "Christopher R. Jones" <cj@stripped>,mysql@stripped
>Subject: Re: Lots of Help Please
>Date: Sat, 22 May 1999 16:40:24 -0600
>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:
> >>Hello All,
> >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
> >>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
> >>may have a similar setup would be able to help me out.
> >>Thank you,
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread3757@stripped
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.
Get Free Email and Do More On The Web. Visit http://www.msn.com