Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

LOAD INFILE NONLOCAL(best way)

Status
Not open for further replies.

svar

Programmer
Aug 12, 2001
349
GR
I have a stream of data arrivinng in one server say every minute or so where they are parsed. Parsing is very fast
and at the end of parsing some files have been written. While I am waiting for the
new data, I want to LOAD these files in a database
on a different machine. Sure, I can ftp them there and run LOAD DATA infile there. Is it possible to do a LOAD DATA INFILE on the remote machine and is it faster than doing the ftp first then load data infile?

Thanks, svar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top