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 your file into (say, x)
2) Figure out how many rows are in each part (y rows * x parts = 10
million rows)
3) copy the ascii file x-1 times
4) edit *1* of the files to only contain the first y rows
5) use LOAD DATA INFILE x times -- the first time you'll use LOAD DATA
INFILE from the file you edited in step 4, the other x-1 times you'll
use LOAD DATA INFILE IGNORE n LINES, where n is y for the 2nd batch,
2y for the 3rd batch, 3y for the 4th batch, 4y for the 5th batch, etc.
If you really are worried about the pre-processing, make a perl
script, or download one like the one at
http://www.hotscripts.com/Detailed/28161.html (note, I claim no
liability, I just found that script doing a web search).
-Sheeri
On 11/22/05, Jacek Becla [EMAIL PROTECTED] wrote:
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 could
pre-process each file and split it, but I'd like to avoid this
extra I/O.
Thanks,
Jacek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
