>Hello All,
>cUT
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.
>
>Thank you,
>
>Sean
>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread3755@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.
>
>
>
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@stripped
