LOAD DATA INFILE from a pipe on Windows.
Posted by: Sela Lerer
Date: September 28, 2005 06:48AM

I tried running this query from a C++ program:
"LOAD DATA INFILE '\\\\\\\\.\\\\pipe\\\\mypipe' INTO TABLE t3"
(so many \ because C++ compile makes each 2 become 1 and the MySQL interpeter does that again!)

I tried it in this version too:
"LOAD DATA INFILE '//./pipe/mypipe' INTO TABLE t3"

Both give me the same error message:
MySQL(29): File '\\pipe\mypipe' not found (Errcode: 2)

It seems that MySQL is changing the file name so the \\. at the beginning is erased.

Did any one succeeded in performing this task? (reading from a Windows pipe)
Any one knows how to over come the problem?

Thank you,
Sela.


P.S.
For the skeptic ones, the pipe does exist and I've succeeded in reading data from with another program useing C++ ifstream object, so a simple file reading code should be able to read from the pipe with no problems.

Options: ReplyQuote


Subject
Views
Written By
Posted
LOAD DATA INFILE from a pipe on Windows.
937
September 28, 2005 06:48AM
419
October 02, 2005 02:33AM
518
October 02, 2005 07:41AM


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.