Re: Feeding data into MySQLdb LOAD DATA from Python

2007-11-14 Thread Larry Bates
John Nagle wrote: > Is it possible to feed data into a LOAD DATA command in MySQL without > writing out the data to a file? It's possible to do this using the > MySQL command line and a UNIX FIFO, but that's kind of clunky. > I have to load a few gigabytes of data, and using INSERT takes > a who

Feeding data into MySQLdb LOAD DATA from Python

2007-11-14 Thread John Nagle
Is it possible to feed data into a LOAD DATA command in MySQL without writing out the data to a file? It's possible to do this using the MySQL command line and a UNIX FIFO, but that's kind of clunky. I have to load a few gigabytes of data, and using INSERT takes a whole day for each update. An