Trouble with LOAD DATA INFILE from WIN

[Anon]

Hi everybody,

i'm in trouble now. On my win98 machine i have installed a mysql server. There is a table. I need to clone it on a far server using vbasic. I tried it like this but it doesent work:

on the local win 98 machine:
select * from katalog into outfile "c:/test.txt";
(this job works)

on the far machine using telnet:
LOAD DATA LOCAL INFILE "c:/test.txt" INTO TABLE katalog;
(err: file... not found)

If anyone could help me please mail me:
<a href="mailto:[e-mail]">[e-mail]</a>

Thanks

[[deleted]]

First, you post here you read the answers here.
We don't email to you personally.

Now, you did first upload the test.txt to the remote server?

[Anon]

No i have not done the upload to the server. Just on my win machine (using the telnet window) i typed the command:

load data local infile "c:/test.txt" into table catalog

I did it like this cos in the mysql manual, there is written:

"The LOAD DATA INFILE statement reads rows from a text file into a table at a very high
speed. If the LOCAL keyword is specified, the file is read from the client (!) host. If LOCAL is
not specified, the file must be located on the server. (LOCAL is available in MySQL 3.22.6
or later.)"

I understood it like this:
c:/test.txt is on my win machine (the client)
and it is loaded into a table on the server

Peter