Feeding data into MySQLdb LOAD DATA from Python

John Nagle nagle at animats.com
Wed Nov 14 14:09:15 EST 2007


   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.

And can this be done portably across UNIX and Windows?  Thanks.

					John Nagle



More information about the Python-list mailing list