I have a lengthy process that consists of these 4 steps:


1) Create a new table and load data into it using LOAD DATA INFILE. The
input file is about 300gb (ASCII). The resulting myisam file is ~100gb
(unpacked).

2) Create two indexes using ALTER TABLE.

3) Pack the table using myisampack -- this wipes the index file from step 2

4) Re-create indexes using myisamchk


Is there a way to skip step 2 and create indexes once, after the table
is packed?


Cheers,
Slawomir