On Fri, Feb 11, 2005, Hans Kristian Rosbach <[EMAIL PROTECTED]> said:
> On Fri, 2005-02-11 at 11:21, [EMAIL PROTECTED] wrote: >> Aaron Stone wrote: >> >> > Take a look at the fifo pipe they use as the 'datafile' about halfway down >> > this page: >> > http://dev.mysql.com/doc/mysql/en/load-data.html >> > >> The requirement for that is that dbmail and the database are on the same >> system I think. That's only true for small systems and small systems >> never should have problems with too much memory usage. > > Yep, so that wouldn't work in our setup atleast. > And is it even supported by anything other than mysql? Creating named pipes as files is standard on unix systems. LOAD DATA INFILE wouldn't know that it's reading anything other than a file... so the only thing needed is to be on the same machine, which is not true of any large installations. Aaron
