On Tuesday 17 December 2002 11:08, moka at hol dot gr wrote: > I am looking at the following situation: > I am reading some files arriving every minute and parsing them and > creating a set of files ready to be inserted into tables. > on the fly. While I am waiting for the next burst of files, I want to > insert these into the tables, then erase the files. > Normally LOAD DATA INFILE LOCAL works fine here. The problem is that > the machine holding these tables is a different one. > The question is, is it possible to run LOAD DATA INFILE > to do the inserts on the remote machine, or is it better to first ftp > the > > files over, then run LOAD DATA INFILE there? > I assume LOAD INFILE is faster than via mysql -u user -ppasswd > DB<file.sql > > where file.sql contains sql INSERT query > > From the LOAD DATA INFILE documentation it is not clear to me how this > can be done, if it can be done.
If you use LOAD DATA LOCAL INFILE, file must be located on the client box. So, you can load data to the remore server. ftp is faster, more reliable, but LOAD DATA LOCAL is easier to use and "cheaper". Besides, to use LOAD DATA you should have FILE privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
