Hi the data is in the text format, the data are separated by , (comma) and are enclosed by " (double quotes).

My requirement is the file resides on Client machine say A and the Database server is on machine say B.

I execute the query from the client machine (A) the query is

LOAD DATA LOCAL INFILE '/usr/local/test.txt' into table Test fields terminated by ',' enclosed by ' " ' lines terminated by '\r\n'

The table Test is on machine B , with the above query the data from the Local text file (test.txt) should be inserted in the Test table of machine B.

If you want more explanation I will provide,

Thanks

Rahul T

-----Original Message----- From: linuxers-admin@mm.ilug-bom.org.in [mailto:linuxers-admin@mm.ilug-bom.org.in]On Behalf Of ranjeet@nttindia.com Sent: Friday, January 04, 2002 12:31 PM To: linuxers@mm.ilug-bom.org.in Subject: [ILUG-BOM] Re: (no subject)

Rahul Torvi writes: Can I insert the data in database that is residing on remote server using LOADDATA IN FILE query ?

what exactely u want to do ? data on remote server means in which format? is it a text file?

or do ya want to connect to the remote machine and insert the data in text file to the database on same server?

elaborate please

regards, ranjeet walunj

_______________________________________________ Meeting on 6th 4pm at IIT Mumbai. See http://www.ilug-bom.org.in/meet/ http://mm.ilug-bom.org.in/mailman/listinfo/linuxers