Re: loading a subset of input file using mysqlimport?

2005-11-28 Thread sheeri kritzer
As far as I can tell, there's no way to do what you specify. If you want less pre-processing, you can use the IGNORE n LINES command of LOAD DATA INFILE: http://dev.mysql.com/doc/refman/5.0/en/load-data.html The pre-processing involved with that is: 1) Decide how many parts you want to split

loading a subset of input file using mysqlimport?

2005-11-22 Thread Jacek Becla
Hi, Is there a way to load a section of an input file into mysql (MyISAM table) using mysqlimport or LOAD DATA INTO? The input data is in relatively large ascii files (10 million rows per file), and I'd like to break the load into smaller pieces rather than load whole file at once. Of course I